Overview
Brought to you by YData
Dataset statistics
| Number of variables | 44 |
|---|---|
| Number of observations | 141250 |
| Missing cells | 443060 |
| Missing cells (%) | 7.1% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 270.7 MiB |
| Average record size in memory | 2.0 KiB |
Variable types
| Categorical | 18 |
|---|---|
| DateTime | 4 |
| Text | 9 |
| Numeric | 8 |
| Unsupported | 2 |
| Boolean | 3 |
GW_Transaction_Status has constant value "settled" | Constant |
GW_Response has constant value "Approved" | Constant |
GW_Trx_Type has constant value "payment" | Constant |
MP_Trx_Type has constant value "payment" | Constant |
Bank_Debits has constant value "0.0" | Constant |
BS_Amount is highly overall correlated with BS_GW_Match and 8 other fields | High correlation |
BS_Card_Type is highly overall correlated with BS_Payment_Gateway and 5 other fields | High correlation |
BS_Currency is highly overall correlated with BS_Foreign_Exchange_Rate and 3 other fields | High correlation |
BS_Foreign_Exchange_Rate is highly overall correlated with BS_Currency and 3 other fields | High correlation |
BS_GW_Match is highly overall correlated with BS_Amount and 16 other fields | High correlation |
BS_Payment_Gateway is highly overall correlated with BS_Card_Type and 7 other fields | High correlation |
BS_Payment_Method_Type is highly overall correlated with BS_Card_Type and 7 other fields | High correlation |
BS_Processor_Response_Message is highly overall correlated with BS_Amount and 10 other fields | High correlation |
BS_Record_Type is highly overall correlated with BS_Amount and 10 other fields | High correlation |
Bank_Credits is highly overall correlated with BS_GW_Match and 7 other fields | High correlation |
Bank_Deposit_Currency is highly overall correlated with BS_Currency and 8 other fields | High correlation |
GW_Card_Brand is highly overall correlated with BS_Card_Type and 6 other fields | High correlation |
GW_Net_Settled_Amt is highly overall correlated with BS_Amount and 4 other fields | High correlation |
GW_Transaction_Amount is highly overall correlated with BS_Amount and 4 other fields | High correlation |
GW_Trx_Currency is highly overall correlated with BS_Currency and 4 other fields | High correlation |
GW_fees is highly overall correlated with BS_Amount and 8 other fields | High correlation |
GW_name is highly overall correlated with BS_Card_Type and 8 other fields | High correlation |
MP_Processor_Fee is highly overall correlated with BS_Card_Type and 10 other fields | High correlation |
MP_Processor_Type is highly overall correlated with BS_Card_Type and 9 other fields | High correlation |
MP_Settled_Amount is highly overall correlated with BS_Amount and 7 other fields | High correlation |
MP_Trx_Currency is highly overall correlated with BS_Currency and 7 other fields | High correlation |
PG_MP_Match is highly overall correlated with BS_Amount and 10 other fields | High correlation |
end_to_end_recon_match is highly overall correlated with BS_Amount and 6 other fields | High correlation |
BS_Record_Type is highly imbalanced (68.6%) | Imbalance |
BS_Processor_Response_Message is highly imbalanced (68.6%) | Imbalance |
BS_GW_Match is highly imbalanced (51.2%) | Imbalance |
GW_Transaction_ID has 15000 (10.6%) missing values | Missing |
GW_name has 15000 (10.6%) missing values | Missing |
GW_Transaction_Status has 15000 (10.6%) missing values | Missing |
GW_Response_Code has 15000 (10.6%) missing values | Missing |
GW_Response has 15000 (10.6%) missing values | Missing |
GW_Transaction_Amount has 15000 (10.6%) missing values | Missing |
GW_Trx_Currency has 15000 (10.6%) missing values | Missing |
GW_Trx_Type has 15000 (10.6%) missing values | Missing |
GW_Card_Brand has 15000 (10.6%) missing values | Missing |
GW_fees has 15000 (10.6%) missing values | Missing |
GW_Net_Settled_Amt has 15000 (10.6%) missing values | Missing |
GW_Trx_Date has 15000 (10.6%) missing values | Missing |
GW_Ref_Number has 15000 (10.6%) missing values | Missing |
MP_Trx_ID has 16250 (11.5%) missing values | Missing |
MP_Processor_Type has 16250 (11.5%) missing values | Missing |
MP_Trx_Type has 16250 (11.5%) missing values | Missing |
MP_Processor_Fee has 16250 (11.5%) missing values | Missing |
MP_Settled_Amount has 16250 (11.5%) missing values | Missing |
MP_Settlement_Date has 16250 (11.5%) missing values | Missing |
MP_Settlement_Batch has 16250 (11.5%) missing values | Missing |
MP_Trx_Currency has 16250 (11.5%) missing values | Missing |
MP_Order_ID has 16250 (11.5%) missing values | Missing |
Bank_Deposit_Date has 20362 (14.4%) missing values | Missing |
Bank_Deposit_Currency has 20362 (14.4%) missing values | Missing |
Bank_Deposit_Ref_Number has 20362 (14.4%) missing values | Missing |
Bank_Credits has 20362 (14.4%) missing values | Missing |
Bank_Debits has 20362 (14.4%) missing values | Missing |
BS_Processor_Response_Code is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
GW_Response_Code is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
MP_Processor_Fee has 83229 (58.9%) zeros | Zeros |
Reproduction
| Analysis started | 2025-07-06 23:53:51.070235 |
|---|---|
| Analysis finished | 2025-07-06 23:54:05.118796 |
| Duration | 14.05 seconds |
| Software version | ydata-profiling vv4.16.1 |
| Download configuration | config.json |
Variables
BS_Record_Type
Categorical
High correlation  Imbalance 
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 7.6 MiB |
| payment | |
|---|---|
| refund | 12500 |
| chargeback | 2500 |
| chargeback_reversal | 1250 |
Length
| Max length | 19 |
|---|---|
| Median length | 7 |
| Mean length | 7.0707965 |
| Min length | 6 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | payment |
|---|---|
| 2nd row | payment |
| 3rd row | payment |
| 4th row | payment |
| 5th row | payment |
Common Values
| Value | Count | Frequency (%) |
| payment | 125000 | |
| refund | 12500 | 8.8% |
| chargeback | 2500 | 1.8% |
| chargeback_reversal | 1250 | 0.9% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| payment | 125000 | |
| refund | 12500 | 8.8% |
| chargeback | 2500 | 1.8% |
| chargeback_reversal | 1250 | 0.9% |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 143750 | |
| n | 137500 | |
| a | 133750 | |
| p | 125000 | |
| y | 125000 | |
| m | 125000 | |
| t | 125000 | |
| r | 18750 | 1.9% |
| u | 12500 | 1.3% |
| d | 12500 | 1.3% |
| Other values (10) | 40000 | 4.0% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 998750 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| e | 143750 | |
| n | 137500 | |
| a | 133750 | |
| p | 125000 | |
| y | 125000 | |
| m | 125000 | |
| t | 125000 | |
| r | 18750 | 1.9% |
| u | 12500 | 1.3% |
| d | 12500 | 1.3% |
| Other values (10) | 40000 | 4.0% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 998750 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| e | 143750 | |
| n | 137500 | |
| a | 133750 | |
| p | 125000 | |
| y | 125000 | |
| m | 125000 | |
| t | 125000 | |
| r | 18750 | 1.9% |
| u | 12500 | 1.3% |
| d | 12500 | 1.3% |
| Other values (10) | 40000 | 4.0% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 998750 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| e | 143750 | |
| n | 137500 | |
| a | 133750 | |
| p | 125000 | |
| y | 125000 | |
| m | 125000 | |
| t | 125000 | |
| r | 18750 | 1.9% |
| u | 12500 | 1.3% |
| d | 12500 | 1.3% |
| Other values (10) | 40000 | 4.0% |
| Distinct | 90 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.1 MiB |
| Minimum | 2025-01-01 00:00:00 |
|---|---|
| Maximum | 2025-03-31 00:00:00 |
| Invalid dates | 0 |
| Invalid dates (%) | 0.0% |
BS_Currency
Categorical
High correlation 
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 7.0 MiB |
| USD | |
|---|---|
| EUR | |
| GBP | |
| AUD | |
| CAD |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | USD |
|---|---|
| 2nd row | USD |
| 3rd row | USD |
| 4th row | GBP |
| 5th row | USD |
Common Values
| Value | Count | Frequency (%) |
| USD | 84784 | |
| EUR | 21002 | 14.9% |
| GBP | 14100 | 10.0% |
| AUD | 11416 | 8.1% |
| CAD | 9948 | 7.0% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| usd | 84784 | |
| eur | 21002 | 14.9% |
| gbp | 14100 | 10.0% |
| aud | 11416 | 8.1% |
| cad | 9948 | 7.0% |
Most occurring characters
| Value | Count | Frequency (%) |
| U | 117202 | |
| D | 106148 | |
| S | 84784 | |
| A | 21364 | 5.0% |
| E | 21002 | 5.0% |
| R | 21002 | 5.0% |
| G | 14100 | 3.3% |
| B | 14100 | 3.3% |
| P | 14100 | 3.3% |
| C | 9948 | 2.3% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 423750 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| U | 117202 | |
| D | 106148 | |
| S | 84784 | |
| A | 21364 | 5.0% |
| E | 21002 | 5.0% |
| R | 21002 | 5.0% |
| G | 14100 | 3.3% |
| B | 14100 | 3.3% |
| P | 14100 | 3.3% |
| C | 9948 | 2.3% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 423750 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| U | 117202 | |
| D | 106148 | |
| S | 84784 | |
| A | 21364 | 5.0% |
| E | 21002 | 5.0% |
| R | 21002 | 5.0% |
| G | 14100 | 3.3% |
| B | 14100 | 3.3% |
| P | 14100 | 3.3% |
| C | 9948 | 2.3% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 423750 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| U | 117202 | |
| D | 106148 | |
| S | 84784 | |
| A | 21364 | 5.0% |
| E | 21002 | 5.0% |
| R | 21002 | 5.0% |
| G | 14100 | 3.3% |
| B | 14100 | 3.3% |
| P | 14100 | 3.3% |
| C | 9948 | 2.3% |
| Distinct | 45195 |
|---|---|
| Distinct (%) | 32.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 7.8 MiB |
Length
| Max length | 9 |
|---|---|
| Median length | 9 |
| Mean length | 8.8150584 |
| Min length | 8 |
Unique
| Unique | 8795 ? |
|---|---|
| Unique (%) | 6.2% |
Sample
| 1st row | CUST15159 |
|---|---|
| 2nd row | CUST20779 |
| 3rd row | CUST28404 |
| 4th row | CUST7007 |
| 5th row | CUST39746 |
| Value | Count | Frequency (%) |
| cust30007 | 16 | < 0.1% |
| cust20916 | 15 | < 0.1% |
| cust49463 | 15 | < 0.1% |
| cust1260 | 15 | < 0.1% |
| cust22216 | 13 | < 0.1% |
| cust9060 | 13 | < 0.1% |
| cust16580 | 13 | < 0.1% |
| cust44259 | 13 | < 0.1% |
| cust8676 | 13 | < 0.1% |
| cust8906 | 13 | < 0.1% |
| Other values (45185) | 141111 |
Most occurring characters
| Value | Count | Frequency (%) |
| C | 141250 | |
| U | 141250 | |
| S | 141250 | |
| T | 141250 | |
| 4 | 86333 | 6.9% |
| 3 | 85701 | 6.9% |
| 1 | 85340 | 6.9% |
| 2 | 85096 | 6.8% |
| 8 | 57083 | 4.6% |
| 9 | 56870 | 4.6% |
| Other values (4) | 223704 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1245127 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| C | 141250 | |
| U | 141250 | |
| S | 141250 | |
| T | 141250 | |
| 4 | 86333 | 6.9% |
| 3 | 85701 | 6.9% |
| 1 | 85340 | 6.9% |
| 2 | 85096 | 6.8% |
| 8 | 57083 | 4.6% |
| 9 | 56870 | 4.6% |
| Other values (4) | 223704 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1245127 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| C | 141250 | |
| U | 141250 | |
| S | 141250 | |
| T | 141250 | |
| 4 | 86333 | 6.9% |
| 3 | 85701 | 6.9% |
| 1 | 85340 | 6.9% |
| 2 | 85096 | 6.8% |
| 8 | 57083 | 4.6% |
| 9 | 56870 | 4.6% |
| Other values (4) | 223704 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1245127 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| C | 141250 | |
| U | 141250 | |
| S | 141250 | |
| T | 141250 | |
| 4 | 86333 | 6.9% |
| 3 | 85701 | 6.9% |
| 1 | 85340 | 6.9% |
| 2 | 85096 | 6.8% |
| 8 | 57083 | 4.6% |
| 9 | 56870 | 4.6% |
| Other values (4) | 223704 |
BS_Amount
Real number (ℝ)
High correlation 
| Distinct | 122801 |
|---|---|
| Distinct (%) | 86.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1979.2208 |
| Minimum | -4999.85 |
|---|---|
| Maximum | 4999.87 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 15000 |
| Negative (%) | 10.6% |
| Memory size | 1.1 MiB |
Quantile statistics
| Minimum | -4999.85 |
|---|---|
| 5-th percentile | -2655.288 |
| Q1 | 828.465 |
| median | 2221.17 |
| Q3 | 3607.4425 |
| 95-th percentile | 4724.491 |
| Maximum | 4999.87 |
| Range | 9999.72 |
| Interquartile range (IQR) | 2778.9775 |
Descriptive statistics
| Standard deviation | 2112.685 |
|---|---|
| Coefficient of variation (CV) | 1.0674327 |
| Kurtosis | 1.0466637 |
| Mean | 1979.2208 |
| Median Absolute Deviation (MAD) | 1389.74 |
| Skewness | -1.0062879 |
| Sum | 2.7956493 × 108 |
| Variance | 4463437.9 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 4756.12 | 5 | < 0.1% |
| 953.97 | 5 | < 0.1% |
| 931.3 | 5 | < 0.1% |
| 3543.24 | 5 | < 0.1% |
| 4146.9 | 5 | < 0.1% |
| 1020.37 | 5 | < 0.1% |
| 1902 | 5 | < 0.1% |
| 2595.9 | 5 | < 0.1% |
| 1121 | 4 | < 0.1% |
| 4540.24 | 4 | < 0.1% |
| Other values (122791) | 141202 |
| Value | Count | Frequency (%) |
| -4999.85 | 1 | |
| -4999.06 | 1 | |
| -4998.84 | 2 | |
| -4998.76 | 1 | |
| -4998.23 | 1 | |
| -4996.55 | 2 | |
| -4996.24 | 1 | |
| -4996.23 | 2 | |
| -4996.21 | 2 | |
| -4995.93 | 1 |
| Value | Count | Frequency (%) |
| 4999.87 | 1 | |
| 4999.85 | 2 | |
| 4999.66 | 1 | |
| 4999.61 | 1 | |
| 4999.54 | 1 | |
| 4999.44 | 1 | |
| 4999.28 | 2 | |
| 4999.27 | 1 | |
| 4999.26 | 1 | |
| 4999.24 | 1 |
BS_Payment_Method_Type
Categorical
High correlation 
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 7.5 MiB |
| Credit Card | |
|---|---|
| PayPal | |
| ACH |
Length
| Max length | 11 |
|---|---|
| Median length | 6 |
| Mean length | 6.6792779 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | PayPal |
|---|---|
| 2nd row | ACH |
| 3rd row | ACH |
| 4th row | Credit Card |
| 5th row | PayPal |
Common Values
| Value | Count | Frequency (%) |
| Credit Card | 47296 | |
| PayPal | 47110 | |
| ACH | 46844 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| credit | 47296 | |
| card | 47296 | |
| paypal | 47110 | |
| ach | 46844 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 141516 | |
| C | 141436 | |
| r | 94592 | |
| d | 94592 | |
| P | 94220 | |
| e | 47296 | 5.0% |
| i | 47296 | 5.0% |
| t | 47296 | 5.0% |
| 47296 | 5.0% | |
| y | 47110 | 5.0% |
| Other values (3) | 140798 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 943448 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| a | 141516 | |
| C | 141436 | |
| r | 94592 | |
| d | 94592 | |
| P | 94220 | |
| e | 47296 | 5.0% |
| i | 47296 | 5.0% |
| t | 47296 | 5.0% |
| 47296 | 5.0% | |
| y | 47110 | 5.0% |
| Other values (3) | 140798 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 943448 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| a | 141516 | |
| C | 141436 | |
| r | 94592 | |
| d | 94592 | |
| P | 94220 | |
| e | 47296 | 5.0% |
| i | 47296 | 5.0% |
| t | 47296 | 5.0% |
| 47296 | 5.0% | |
| y | 47110 | 5.0% |
| Other values (3) | 140798 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 943448 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| a | 141516 | |
| C | 141436 | |
| r | 94592 | |
| d | 94592 | |
| P | 94220 | |
| e | 47296 | 5.0% |
| i | 47296 | 5.0% |
| t | 47296 | 5.0% |
| 47296 | 5.0% | |
| y | 47110 | 5.0% |
| Other values (3) | 140798 |
BS_Card_Type
Categorical
High correlation 
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 7.3 MiB |
| PayPal | |
|---|---|
| ACH | |
| Mastercard | |
| Visa | |
| Amex |
Length
| Max length | 10 |
|---|---|
| Median length | 6 |
| Mean length | 5.0133522 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | PayPal |
|---|---|
| 2nd row | ACH |
| 3rd row | ACH |
| 4th row | Visa |
| 5th row | PayPal |
Common Values
| Value | Count | Frequency (%) |
| PayPal | 47110 | |
| ACH | 46844 | |
| Mastercard | 15960 | 11.3% |
| Visa | 15697 | 11.1% |
| Amex | 15639 | 11.1% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| paypal | 47110 | |
| ach | 46844 | |
| mastercard | 15960 | 11.3% |
| visa | 15697 | 11.1% |
| amex | 15639 | 11.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 141837 | |
| P | 94220 | |
| A | 62483 | |
| y | 47110 | 6.7% |
| l | 47110 | 6.7% |
| C | 46844 | 6.6% |
| H | 46844 | 6.6% |
| r | 31920 | 4.5% |
| s | 31657 | 4.5% |
| e | 31599 | 4.5% |
| Other values (8) | 126512 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 708136 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| a | 141837 | |
| P | 94220 | |
| A | 62483 | |
| y | 47110 | 6.7% |
| l | 47110 | 6.7% |
| C | 46844 | 6.6% |
| H | 46844 | 6.6% |
| r | 31920 | 4.5% |
| s | 31657 | 4.5% |
| e | 31599 | 4.5% |
| Other values (8) | 126512 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 708136 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| a | 141837 | |
| P | 94220 | |
| A | 62483 | |
| y | 47110 | 6.7% |
| l | 47110 | 6.7% |
| C | 46844 | 6.6% |
| H | 46844 | 6.6% |
| r | 31920 | 4.5% |
| s | 31657 | 4.5% |
| e | 31599 | 4.5% |
| Other values (8) | 126512 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 708136 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| a | 141837 | |
| P | 94220 | |
| A | 62483 | |
| y | 47110 | 6.7% |
| l | 47110 | 6.7% |
| C | 46844 | 6.6% |
| H | 46844 | 6.6% |
| r | 31920 | 4.5% |
| s | 31657 | 4.5% |
| e | 31599 | 4.5% |
| Other values (8) | 126512 |
| Distinct | 124907 |
|---|---|
| Distinct (%) | 88.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 8.4 MiB |
Length
| Max length | 13 |
|---|---|
| Median length | 13 |
| Mean length | 13 |
| Min length | 13 |
Unique
| Unique | 112330 ? |
|---|---|
| Unique (%) | 79.5% |
Sample
| 1st row | PROC-21233551 |
|---|---|
| 2nd row | PROC-45142454 |
| 3rd row | PROC-76309118 |
| 4th row | PROC-62839998 |
| 5th row | PROC-62414033 |
| Value | Count | Frequency (%) |
| proc-54910620 | 4 | < 0.1% |
| proc-99885580 | 4 | < 0.1% |
| proc-82847137 | 4 | < 0.1% |
| proc-34872954 | 4 | < 0.1% |
| proc-52280805 | 4 | < 0.1% |
| proc-33425997 | 4 | < 0.1% |
| proc-81472295 | 4 | < 0.1% |
| proc-28936129 | 4 | < 0.1% |
| proc-30105287 | 4 | < 0.1% |
| proc-19700926 | 4 | < 0.1% |
| Other values (124897) | 141210 |
Most occurring characters
| Value | Count | Frequency (%) |
| P | 141250 | 7.7% |
| R | 141250 | 7.7% |
| O | 141250 | 7.7% |
| C | 141250 | 7.7% |
| - | 141250 | 7.7% |
| 7 | 115128 | 6.3% |
| 8 | 115060 | 6.3% |
| 1 | 114741 | 6.2% |
| 4 | 114512 | 6.2% |
| 3 | 114444 | 6.2% |
| Other values (5) | 556115 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1836250 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| P | 141250 | 7.7% |
| R | 141250 | 7.7% |
| O | 141250 | 7.7% |
| C | 141250 | 7.7% |
| - | 141250 | 7.7% |
| 7 | 115128 | 6.3% |
| 8 | 115060 | 6.3% |
| 1 | 114741 | 6.2% |
| 4 | 114512 | 6.2% |
| 3 | 114444 | 6.2% |
| Other values (5) | 556115 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1836250 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| P | 141250 | 7.7% |
| R | 141250 | 7.7% |
| O | 141250 | 7.7% |
| C | 141250 | 7.7% |
| - | 141250 | 7.7% |
| 7 | 115128 | 6.3% |
| 8 | 115060 | 6.3% |
| 1 | 114741 | 6.2% |
| 4 | 114512 | 6.2% |
| 3 | 114444 | 6.2% |
| Other values (5) | 556115 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1836250 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| P | 141250 | 7.7% |
| R | 141250 | 7.7% |
| O | 141250 | 7.7% |
| C | 141250 | 7.7% |
| - | 141250 | 7.7% |
| 7 | 115128 | 6.3% |
| 8 | 115060 | 6.3% |
| 1 | 114741 | 6.2% |
| 4 | 114512 | 6.2% |
| 3 | 114444 | 6.2% |
| Other values (5) | 556115 |
BS_Payment_Gateway
Categorical
High correlation 
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 7.8 MiB |
| Cybersource | |
|---|---|
| PayPal | |
| GoCardless |
Length
| Max length | 11 |
|---|---|
| Median length | 10 |
| Mean length | 9.0007504 |
| Min length | 6 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | PayPal |
|---|---|
| 2nd row | GoCardless |
| 3rd row | GoCardless |
| 4th row | Cybersource |
| 5th row | PayPal |
Common Values
| Value | Count | Frequency (%) |
| Cybersource | 47296 | |
| PayPal | 47110 | |
| GoCardless | 46844 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| cybersource | 47296 | |
| paypal | 47110 | |
| gocardless | 46844 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 141436 | |
| r | 141436 | |
| a | 141064 | |
| s | 140984 | |
| y | 94406 | |
| P | 94220 | |
| C | 94140 | |
| o | 94140 | |
| l | 93954 | |
| b | 47296 | 3.7% |
| Other values (4) | 188280 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1271356 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| e | 141436 | |
| r | 141436 | |
| a | 141064 | |
| s | 140984 | |
| y | 94406 | |
| P | 94220 | |
| C | 94140 | |
| o | 94140 | |
| l | 93954 | |
| b | 47296 | 3.7% |
| Other values (4) | 188280 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1271356 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| e | 141436 | |
| r | 141436 | |
| a | 141064 | |
| s | 140984 | |
| y | 94406 | |
| P | 94220 | |
| C | 94140 | |
| o | 94140 | |
| l | 93954 | |
| b | 47296 | 3.7% |
| Other values (4) | 188280 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1271356 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| e | 141436 | |
| r | 141436 | |
| a | 141064 | |
| s | 140984 | |
| y | 94406 | |
| P | 94220 | |
| C | 94140 | |
| o | 94140 | |
| l | 93954 | |
| b | 47296 | 3.7% |
| Other values (4) | 188280 |
BS_Processor_Response_Code
Unsupported
Rejected  Unsupported 
| Missing | 0 |
|---|---|
| Missing (%) | 0.0% |
| Memory size | 5.5 MiB |
BS_Processor_Response_Message
Categorical
High correlation  Imbalance 
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 7.8 MiB |
| Approved | |
|---|---|
| Refund Processed | 12500 |
| Chargeback Initiated | 2500 |
| Chargeback Reversed | 1250 |
Length
| Max length | 20 |
|---|---|
| Median length | 8 |
| Mean length | 9.0176991 |
| Min length | 8 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Approved |
|---|---|
| 2nd row | Approved |
| 3rd row | Approved |
| 4th row | Approved |
| 5th row | Approved |
Common Values
| Value | Count | Frequency (%) |
| Approved | 125000 | |
| Refund Processed | 12500 | 8.8% |
| Chargeback Initiated | 2500 | 1.8% |
| Chargeback Reversed | 1250 | 0.9% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| approved | 125000 | |
| refund | 12500 | 7.9% |
| processed | 12500 | 7.9% |
| chargeback | 3750 | 2.4% |
| initiated | 2500 | 1.6% |
| reversed | 1250 | 0.8% |
Most occurring characters
| Value | Count | Frequency (%) |
| p | 250000 | |
| e | 172500 | |
| d | 153750 | |
| r | 142500 | |
| o | 137500 | |
| v | 126250 | |
| A | 125000 | |
| s | 26250 | 2.1% |
| c | 16250 | 1.3% |
| 16250 | 1.3% | |
| Other values (14) | 107500 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1273750 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| p | 250000 | |
| e | 172500 | |
| d | 153750 | |
| r | 142500 | |
| o | 137500 | |
| v | 126250 | |
| A | 125000 | |
| s | 26250 | 2.1% |
| c | 16250 | 1.3% |
| 16250 | 1.3% | |
| Other values (14) | 107500 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1273750 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| p | 250000 | |
| e | 172500 | |
| d | 153750 | |
| r | 142500 | |
| o | 137500 | |
| v | 126250 | |
| A | 125000 | |
| s | 26250 | 2.1% |
| c | 16250 | 1.3% |
| 16250 | 1.3% | |
| Other values (14) | 107500 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1273750 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| p | 250000 | |
| e | 172500 | |
| d | 153750 | |
| r | 142500 | |
| o | 137500 | |
| v | 126250 | |
| A | 125000 | |
| s | 26250 | 2.1% |
| c | 16250 | 1.3% |
| 16250 | 1.3% | |
| Other values (14) | 107500 |
| Distinct | 125000 |
|---|---|
| Distinct (%) | 88.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 8.1 MiB |
Length
| Max length | 11 |
|---|---|
| Median length | 11 |
| Mean length | 11 |
| Min length | 11 |
Unique
| Unique | 112500 ? |
|---|---|
| Unique (%) | 79.6% |
Sample
| 1st row | PAY-0000000 |
|---|---|
| 2nd row | PAY-0000001 |
| 3rd row | PAY-0000002 |
| 4th row | PAY-0000003 |
| 5th row | PAY-0000004 |
| Value | Count | Frequency (%) |
| pay-0038489 | 4 | < 0.1% |
| pay-0033214 | 4 | < 0.1% |
| pay-0066396 | 4 | < 0.1% |
| pay-0063049 | 4 | < 0.1% |
| pay-0124481 | 4 | < 0.1% |
| pay-0064521 | 4 | < 0.1% |
| pay-0113868 | 4 | < 0.1% |
| pay-0030656 | 4 | < 0.1% |
| pay-0032004 | 4 | < 0.1% |
| pay-0063738 | 4 | < 0.1% |
| Other values (124990) | 141210 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 334091 | |
| P | 141250 | |
| A | 141250 | |
| Y | 141250 | |
| - | 141250 | |
| 1 | 107672 | 6.9% |
| 2 | 73838 | 4.8% |
| 4 | 68511 | 4.4% |
| 3 | 68239 | 4.4% |
| 5 | 67331 | 4.3% |
| Other values (4) | 269068 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1553750 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 334091 | |
| P | 141250 | |
| A | 141250 | |
| Y | 141250 | |
| - | 141250 | |
| 1 | 107672 | 6.9% |
| 2 | 73838 | 4.8% |
| 4 | 68511 | 4.4% |
| 3 | 68239 | 4.4% |
| 5 | 67331 | 4.3% |
| Other values (4) | 269068 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1553750 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 334091 | |
| P | 141250 | |
| A | 141250 | |
| Y | 141250 | |
| - | 141250 | |
| 1 | 107672 | 6.9% |
| 2 | 73838 | 4.8% |
| 4 | 68511 | 4.4% |
| 3 | 68239 | 4.4% |
| 5 | 67331 | 4.3% |
| Other values (4) | 269068 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1553750 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 334091 | |
| P | 141250 | |
| A | 141250 | |
| Y | 141250 | |
| - | 141250 | |
| 1 | 107672 | 6.9% |
| 2 | 73838 | 4.8% |
| 4 | 68511 | 4.4% |
| 3 | 68239 | 4.4% |
| 5 | 67331 | 4.3% |
| Other values (4) | 269068 |
BS_Sales_Channel
Categorical
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 7.5 MiB |
| In-Store | |
|---|---|
| Online | |
| Phone |
Length
| Max length | 8 |
|---|---|
| Median length | 6 |
| Mean length | 6.3382796 |
| Min length | 5 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | In-Store |
|---|---|
| 2nd row | In-Store |
| 3rd row | Phone |
| 4th row | Phone |
| 5th row | In-Store |
Common Values
| Value | Count | Frequency (%) |
| In-Store | 47295 | |
| Online | 47147 | |
| Phone | 46808 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| in-store | 47295 | |
| online | 47147 | |
| phone | 46808 |
Most occurring characters
| Value | Count | Frequency (%) |
| n | 188397 | |
| e | 141250 | |
| o | 94103 | |
| I | 47295 | 5.3% |
| - | 47295 | 5.3% |
| S | 47295 | 5.3% |
| t | 47295 | 5.3% |
| r | 47295 | 5.3% |
| O | 47147 | 5.3% |
| l | 47147 | 5.3% |
| Other values (3) | 140763 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 895282 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| n | 188397 | |
| e | 141250 | |
| o | 94103 | |
| I | 47295 | 5.3% |
| - | 47295 | 5.3% |
| S | 47295 | 5.3% |
| t | 47295 | 5.3% |
| r | 47295 | 5.3% |
| O | 47147 | 5.3% |
| l | 47147 | 5.3% |
| Other values (3) | 140763 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 895282 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| n | 188397 | |
| e | 141250 | |
| o | 94103 | |
| I | 47295 | 5.3% |
| - | 47295 | 5.3% |
| S | 47295 | 5.3% |
| t | 47295 | 5.3% |
| r | 47295 | 5.3% |
| O | 47147 | 5.3% |
| l | 47147 | 5.3% |
| Other values (3) | 140763 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 895282 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| n | 188397 | |
| e | 141250 | |
| o | 94103 | |
| I | 47295 | 5.3% |
| - | 47295 | 5.3% |
| S | 47295 | 5.3% |
| t | 47295 | 5.3% |
| r | 47295 | 5.3% |
| O | 47147 | 5.3% |
| l | 47147 | 5.3% |
| Other values (3) | 140763 |
BS_Foreign_Exchange_Rate
Real number (ℝ)
High correlation 
| Distinct | 953 |
|---|---|
| Distinct (%) | 0.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.99235357 |
| Minimum | 0.6534 |
|---|---|
| Maximum | 1.2827 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.1 MiB |
Quantile statistics
| Minimum | 0.6534 |
|---|---|
| 5-th percentile | 0.6614 |
| Q1 | 0.9933 |
| median | 1.0016 |
| Q3 | 1.01 |
| 95-th percentile | 1.2702 |
| Maximum | 1.2827 |
| Range | 0.6293 |
| Interquartile range (IQR) | 0.0167 |
Descriptive statistics
| Standard deviation | 0.15062953 |
|---|---|
| Coefficient of variation (CV) | 0.15179019 |
| Kurtosis | 0.74384548 |
| Mean | 0.99235357 |
| Median Absolute Deviation (MAD) | 0.0083 |
| Skewness | -0.5844689 |
| Sum | 140169.94 |
| Variance | 0.022689257 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1.0012 | 481 | 0.3% |
| 0.9918 | 478 | 0.3% |
| 0.9925 | 476 | 0.3% |
| 0.997 | 472 | 0.3% |
| 0.9978 | 468 | 0.3% |
| 0.9963 | 465 | 0.3% |
| 0.9905 | 465 | 0.3% |
| 0.9928 | 463 | 0.3% |
| 1.0054 | 462 | 0.3% |
| 1.0005 | 462 | 0.3% |
| Other values (943) | 136558 |
| Value | Count | Frequency (%) |
| 0.6534 | 49 | |
| 0.6535 | 91 | |
| 0.6536 | 86 | |
| 0.6537 | 87 | |
| 0.6538 | 85 | |
| 0.6539 | 105 | |
| 0.654 | 83 | |
| 0.6541 | 105 | |
| 0.6542 | 96 | |
| 0.6543 | 73 |
| Value | Count | Frequency (%) |
| 1.2827 | 34 | |
| 1.2826 | 58 | |
| 1.2825 | 66 | |
| 1.2824 | 44 | |
| 1.2823 | 46 | |
| 1.2822 | 33 | |
| 1.2821 | 42 | |
| 1.282 | 52 | |
| 1.2819 | 61 | |
| 1.2818 | 56 |
Missing 
| Distinct | 124128 |
|---|---|
| Distinct (%) | 98.3% |
| Missing | 15000 |
| Missing (%) | 10.6% |
| Memory size | 8.0 MiB |
Length
| Max length | 14 |
|---|---|
| Median length | 14 |
| Mean length | 14 |
| Min length | 14 |
Unique
| Unique | 122024 ? |
|---|---|
| Unique (%) | 96.7% |
Sample
| 1st row | GW-TRX-9972261 |
|---|---|
| 2nd row | GW-TRX-8455695 |
| 3rd row | GW-TRX-5184318 |
| 4th row | GW-TRX-8104962 |
| 5th row | GW-TRX-2770667 |
| Value | Count | Frequency (%) |
| gw-trx-8805233 | 4 | < 0.1% |
| gw-trx-4653021 | 3 | < 0.1% |
| gw-trx-1392363 | 3 | < 0.1% |
| gw-trx-4044666 | 3 | < 0.1% |
| gw-trx-4979170 | 3 | < 0.1% |
| gw-trx-5701527 | 3 | < 0.1% |
| gw-trx-4420744 | 3 | < 0.1% |
| gw-trx-3932125 | 3 | < 0.1% |
| gw-trx-5469733 | 3 | < 0.1% |
| gw-trx-3951989 | 3 | < 0.1% |
| Other values (124118) | 126219 |
Most occurring characters
| Value | Count | Frequency (%) |
| - | 252500 | |
| G | 126250 | 7.1% |
| W | 126250 | 7.1% |
| T | 126250 | 7.1% |
| R | 126250 | 7.1% |
| X | 126250 | 7.1% |
| 2 | 90204 | 5.1% |
| 3 | 89943 | 5.1% |
| 4 | 89913 | 5.1% |
| 6 | 89744 | 5.1% |
| Other values (6) | 523946 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1767500 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| - | 252500 | |
| G | 126250 | 7.1% |
| W | 126250 | 7.1% |
| T | 126250 | 7.1% |
| R | 126250 | 7.1% |
| X | 126250 | 7.1% |
| 2 | 90204 | 5.1% |
| 3 | 89943 | 5.1% |
| 4 | 89913 | 5.1% |
| 6 | 89744 | 5.1% |
| Other values (6) | 523946 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1767500 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| - | 252500 | |
| G | 126250 | 7.1% |
| W | 126250 | 7.1% |
| T | 126250 | 7.1% |
| R | 126250 | 7.1% |
| X | 126250 | 7.1% |
| 2 | 90204 | 5.1% |
| 3 | 89943 | 5.1% |
| 4 | 89913 | 5.1% |
| 6 | 89744 | 5.1% |
| Other values (6) | 523946 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1767500 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| - | 252500 | |
| G | 126250 | 7.1% |
| W | 126250 | 7.1% |
| T | 126250 | 7.1% |
| R | 126250 | 7.1% |
| X | 126250 | 7.1% |
| 2 | 90204 | 5.1% |
| 3 | 89943 | 5.1% |
| 4 | 89913 | 5.1% |
| 6 | 89744 | 5.1% |
| Other values (6) | 523946 |
GW_name
Categorical
High correlation  Missing 
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 15000 |
| Missing (%) | 10.6% |
| Memory size | 7.8 MiB |
| Cybersource | |
|---|---|
| PayPal | |
| GoCardless |
Length
| Max length | 11 |
|---|---|
| Median length | 10 |
| Mean length | 8.9997386 |
| Min length | 6 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | PayPal |
|---|---|
| 2nd row | GoCardless |
| 3rd row | GoCardless |
| 4th row | Cybersource |
| 5th row | PayPal |
Common Values
| Value | Count | Frequency (%) |
| Cybersource | 42213 | |
| PayPal | 42124 | |
| GoCardless | 41913 | |
| (Missing) | 15000 | 10.6% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| cybersource | 42213 | |
| paypal | 42124 | |
| gocardless | 41913 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 126339 | |
| r | 126339 | |
| a | 126161 | |
| s | 126039 | |
| y | 84337 | |
| P | 84248 | |
| C | 84126 | |
| o | 84126 | |
| l | 84037 | |
| b | 42213 | 3.7% |
| Other values (4) | 168252 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1136217 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| e | 126339 | |
| r | 126339 | |
| a | 126161 | |
| s | 126039 | |
| y | 84337 | |
| P | 84248 | |
| C | 84126 | |
| o | 84126 | |
| l | 84037 | |
| b | 42213 | 3.7% |
| Other values (4) | 168252 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1136217 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| e | 126339 | |
| r | 126339 | |
| a | 126161 | |
| s | 126039 | |
| y | 84337 | |
| P | 84248 | |
| C | 84126 | |
| o | 84126 | |
| l | 84037 | |
| b | 42213 | 3.7% |
| Other values (4) | 168252 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1136217 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| e | 126339 | |
| r | 126339 | |
| a | 126161 | |
| s | 126039 | |
| y | 84337 | |
| P | 84248 | |
| C | 84126 | |
| o | 84126 | |
| l | 84037 | |
| b | 42213 | 3.7% |
| Other values (4) | 168252 |
GW_Transaction_Status
Categorical
Constant  Missing 
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 15000 |
| Missing (%) | 10.6% |
| Memory size | 7.5 MiB |
| settled |
|---|
Length
| Max length | 7 |
|---|---|
| Median length | 7 |
| Mean length | 7 |
| Min length | 7 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | settled |
|---|---|
| 2nd row | settled |
| 3rd row | settled |
| 4th row | settled |
| 5th row | settled |
Common Values
| Value | Count | Frequency (%) |
| settled | 126250 | |
| (Missing) | 15000 | 10.6% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| settled | 126250 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 252500 | |
| t | 252500 | |
| s | 126250 | |
| l | 126250 | |
| d | 126250 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 883750 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| e | 252500 | |
| t | 252500 | |
| s | 126250 | |
| l | 126250 | |
| d | 126250 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 883750 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| e | 252500 | |
| t | 252500 | |
| s | 126250 | |
| l | 126250 | |
| d | 126250 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 883750 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| e | 252500 | |
| t | 252500 | |
| s | 126250 | |
| l | 126250 | |
| d | 126250 |
GW_Response_Code
Unsupported
Missing  Rejected  Unsupported 
| Missing | 15000 |
|---|---|
| Missing (%) | 10.6% |
| Memory size | 5.2 MiB |
GW_Response
Categorical
Constant  Missing 
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 15000 |
| Missing (%) | 10.6% |
| Memory size | 7.7 MiB |
| Approved |
|---|
Length
| Max length | 8 |
|---|---|
| Median length | 8 |
| Mean length | 8 |
| Min length | 8 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Approved |
|---|---|
| 2nd row | Approved |
| 3rd row | Approved |
| 4th row | Approved |
| 5th row | Approved |
Common Values
| Value | Count | Frequency (%) |
| Approved | 126250 | |
| (Missing) | 15000 | 10.6% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| approved | 126250 |
Most occurring characters
| Value | Count | Frequency (%) |
| p | 252500 | |
| A | 126250 | |
| r | 126250 | |
| o | 126250 | |
| v | 126250 | |
| e | 126250 | |
| d | 126250 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1010000 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| p | 252500 | |
| A | 126250 | |
| r | 126250 | |
| o | 126250 | |
| v | 126250 | |
| e | 126250 | |
| d | 126250 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1010000 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| p | 252500 | |
| A | 126250 | |
| r | 126250 | |
| o | 126250 | |
| v | 126250 | |
| e | 126250 | |
| d | 126250 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1010000 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| p | 252500 | |
| A | 126250 | |
| r | 126250 | |
| o | 126250 | |
| v | 126250 | |
| e | 126250 | |
| d | 126250 |
GW_Transaction_Amount
Real number (ℝ)
High correlation  Missing 
| Distinct | 110454 |
|---|---|
| Distinct (%) | 87.5% |
| Missing | 15000 |
| Missing (%) | 10.6% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2513.3731 |
| Minimum | 25.08 |
|---|---|
| Maximum | 4999.87 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.1 MiB |
Quantile statistics
| Minimum | 25.08 |
|---|---|
| 5-th percentile | 270.357 |
| Q1 | 1269.245 |
| median | 2512.08 |
| Q3 | 3756.1275 |
| 95-th percentile | 4751.42 |
| Maximum | 4999.87 |
| Range | 4974.79 |
| Interquartile range (IQR) | 2486.8825 |
Descriptive statistics
| Standard deviation | 1436.5054 |
|---|---|
| Coefficient of variation (CV) | 0.57154485 |
| Kurtosis | -1.1975413 |
| Mean | 2513.3731 |
| Median Absolute Deviation (MAD) | 1243.5 |
| Skewness | 0.00018353774 |
| Sum | 3.1731335 × 108 |
| Variance | 2063547.9 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 3543.24 | 5 | < 0.1% |
| 4756.12 | 5 | < 0.1% |
| 1902 | 5 | < 0.1% |
| 4146.9 | 5 | < 0.1% |
| 2595.9 | 5 | < 0.1% |
| 931.3 | 5 | < 0.1% |
| 1020.37 | 5 | < 0.1% |
| 953.97 | 5 | < 0.1% |
| 4610.19 | 4 | < 0.1% |
| 659.95 | 4 | < 0.1% |
| Other values (110444) | 126202 | |
| (Missing) | 15000 | 10.6% |
| Value | Count | Frequency (%) |
| 25.08 | 1 | |
| 25.15 | 1 | |
| 25.16 | 1 | |
| 25.31 | 1 | |
| 25.32 | 1 | |
| 25.34 | 1 | |
| 25.37 | 2 | |
| 25.4 | 1 | |
| 25.47 | 1 | |
| 25.48 | 1 |
| Value | Count | Frequency (%) |
| 4999.87 | 1 | |
| 4999.85 | 2 | |
| 4999.66 | 1 | |
| 4999.61 | 1 | |
| 4999.54 | 1 | |
| 4999.44 | 1 | |
| 4999.28 | 2 | |
| 4999.27 | 1 | |
| 4999.26 | 1 | |
| 4999.24 | 1 |
GW_Trx_Currency
Categorical
High correlation  Missing 
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 15000 |
| Missing (%) | 10.6% |
| Memory size | 7.1 MiB |
| USD | |
|---|---|
| EUR | |
| GBP | |
| AUD | |
| CAD |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | USD |
|---|---|
| 2nd row | USD |
| 3rd row | USD |
| 4th row | GBP |
| 5th row | USD |
Common Values
| Value | Count | Frequency (%) |
| USD | 75838 | |
| EUR | 18783 | 13.3% |
| GBP | 12585 | 8.9% |
| AUD | 10152 | 7.2% |
| CAD | 8892 | 6.3% |
| (Missing) | 15000 | 10.6% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| usd | 75838 | |
| eur | 18783 | 14.9% |
| gbp | 12585 | 10.0% |
| aud | 10152 | 8.0% |
| cad | 8892 | 7.0% |
Most occurring characters
| Value | Count | Frequency (%) |
| U | 104773 | |
| D | 94882 | |
| S | 75838 | |
| A | 19044 | 5.0% |
| E | 18783 | 5.0% |
| R | 18783 | 5.0% |
| G | 12585 | 3.3% |
| B | 12585 | 3.3% |
| P | 12585 | 3.3% |
| C | 8892 | 2.3% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 378750 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| U | 104773 | |
| D | 94882 | |
| S | 75838 | |
| A | 19044 | 5.0% |
| E | 18783 | 5.0% |
| R | 18783 | 5.0% |
| G | 12585 | 3.3% |
| B | 12585 | 3.3% |
| P | 12585 | 3.3% |
| C | 8892 | 2.3% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 378750 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| U | 104773 | |
| D | 94882 | |
| S | 75838 | |
| A | 19044 | 5.0% |
| E | 18783 | 5.0% |
| R | 18783 | 5.0% |
| G | 12585 | 3.3% |
| B | 12585 | 3.3% |
| P | 12585 | 3.3% |
| C | 8892 | 2.3% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 378750 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| U | 104773 | |
| D | 94882 | |
| S | 75838 | |
| A | 19044 | 5.0% |
| E | 18783 | 5.0% |
| R | 18783 | 5.0% |
| G | 12585 | 3.3% |
| B | 12585 | 3.3% |
| P | 12585 | 3.3% |
| C | 8892 | 2.3% |
GW_Trx_Type
Categorical
Constant  Missing 
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 15000 |
| Missing (%) | 10.6% |
| Memory size | 7.5 MiB |
| payment |
|---|
Length
| Max length | 7 |
|---|---|
| Median length | 7 |
| Mean length | 7 |
| Min length | 7 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | payment |
|---|---|
| 2nd row | payment |
| 3rd row | payment |
| 4th row | payment |
| 5th row | payment |
Common Values
| Value | Count | Frequency (%) |
| payment | 126250 | |
| (Missing) | 15000 | 10.6% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| payment | 126250 |
Most occurring characters
| Value | Count | Frequency (%) |
| p | 126250 | |
| a | 126250 | |
| y | 126250 | |
| m | 126250 | |
| e | 126250 | |
| n | 126250 | |
| t | 126250 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 883750 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| p | 126250 | |
| a | 126250 | |
| y | 126250 | |
| m | 126250 | |
| e | 126250 | |
| n | 126250 | |
| t | 126250 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 883750 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| p | 126250 | |
| a | 126250 | |
| y | 126250 | |
| m | 126250 | |
| e | 126250 | |
| n | 126250 | |
| t | 126250 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 883750 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| p | 126250 | |
| a | 126250 | |
| y | 126250 | |
| m | 126250 | |
| e | 126250 | |
| n | 126250 | |
| t | 126250 |
GW_Card_Brand
Categorical
High correlation  Missing 
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 15000 |
| Missing (%) | 10.6% |
| Memory size | 7.6 MiB |
| PayPal | |
|---|---|
| GoCardless | |
| Mastercard | |
| Visa | |
| Amex |
Length
| Max length | 10 |
|---|---|
| Median length | 6 |
| Mean length | 7.3351604 |
| Min length | 4 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | PayPal |
|---|---|
| 2nd row | GoCardless |
| 3rd row | GoCardless |
| 4th row | Visa |
| 5th row | PayPal |
Common Values
| Value | Count | Frequency (%) |
| PayPal | 42124 | |
| GoCardless | 41913 | |
| Mastercard | 14223 | 10.1% |
| Visa | 13996 | 9.9% |
| Amex | 13994 | 9.9% |
| (Missing) | 15000 | 10.6% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| paypal | 42124 | |
| gocardless | 41913 | |
| mastercard | 14223 | 11.3% |
| visa | 13996 | 11.1% |
| amex | 13994 | 11.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 168603 | |
| s | 112045 | |
| P | 84248 | |
| l | 84037 | |
| r | 70359 | |
| e | 70130 | |
| d | 56136 | 6.1% |
| y | 42124 | 4.5% |
| C | 41913 | 4.5% |
| o | 41913 | 4.5% |
| Other values (9) | 154556 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 926064 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| a | 168603 | |
| s | 112045 | |
| P | 84248 | |
| l | 84037 | |
| r | 70359 | |
| e | 70130 | |
| d | 56136 | 6.1% |
| y | 42124 | 4.5% |
| C | 41913 | 4.5% |
| o | 41913 | 4.5% |
| Other values (9) | 154556 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 926064 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| a | 168603 | |
| s | 112045 | |
| P | 84248 | |
| l | 84037 | |
| r | 70359 | |
| e | 70130 | |
| d | 56136 | 6.1% |
| y | 42124 | 4.5% |
| C | 41913 | 4.5% |
| o | 41913 | 4.5% |
| Other values (9) | 154556 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 926064 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| a | 168603 | |
| s | 112045 | |
| P | 84248 | |
| l | 84037 | |
| r | 70359 | |
| e | 70130 | |
| d | 56136 | 6.1% |
| y | 42124 | 4.5% |
| C | 41913 | 4.5% |
| o | 41913 | 4.5% |
| Other values (9) | 154556 |
GW_fees
Real number (ℝ)
High correlation  Missing 
| Distinct | 4995 |
|---|---|
| Distinct (%) | 4.0% |
| Missing | 15000 |
| Missing (%) | 10.6% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 16.786014 |
| Minimum | 0.06 |
|---|---|
| Maximum | 50 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.1 MiB |
Quantile statistics
| Minimum | 0.06 |
|---|---|
| 5-th percentile | 1.3 |
| Q1 | 6.03 |
| median | 11.95 |
| Q3 | 26.93 |
| 95-th percentile | 42.59 |
| Maximum | 50 |
| Range | 49.94 |
| Interquartile range (IQR) | 20.9 |
Descriptive statistics
| Standard deviation | 13.169925 |
|---|---|
| Coefficient of variation (CV) | 0.78457725 |
| Kurtosis | -0.59754096 |
| Mean | 16.786014 |
| Median Absolute Deviation (MAD) | 8.39 |
| Skewness | 0.72097683 |
| Sum | 2119234.3 |
| Variance | 173.44692 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 3.94 | 77 | 0.1% |
| 0.73 | 76 | 0.1% |
| 3.19 | 75 | 0.1% |
| 10.64 | 75 | 0.1% |
| 5.52 | 75 | 0.1% |
| 7.95 | 74 | 0.1% |
| 5.82 | 74 | 0.1% |
| 7.99 | 73 | 0.1% |
| 4.84 | 72 | 0.1% |
| 2.21 | 72 | 0.1% |
| Other values (4985) | 125507 | |
| (Missing) | 15000 | 10.6% |
| Value | Count | Frequency (%) |
| 0.06 | 12 | < 0.1% |
| 0.07 | 34 | |
| 0.08 | 41 | |
| 0.09 | 26 | |
| 0.1 | 37 | |
| 0.11 | 38 | |
| 0.12 | 39 | |
| 0.13 | 33 | |
| 0.14 | 29 | |
| 0.15 | 40 |
| Value | Count | Frequency (%) |
| 50 | 2 | < 0.1% |
| 49.99 | 6 | |
| 49.98 | 6 | |
| 49.97 | 4 | < 0.1% |
| 49.96 | 12 | |
| 49.95 | 11 | |
| 49.94 | 8 | |
| 49.93 | 12 | |
| 49.92 | 6 | |
| 49.91 | 6 |
GW_Net_Settled_Amt
Real number (ℝ)
High correlation  Missing 
| Distinct | 112419 |
|---|---|
| Distinct (%) | 89.0% |
| Missing | 15000 |
| Missing (%) | 10.6% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2496.5871 |
| Minimum | 24.89 |
|---|---|
| Maximum | 4987.37 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.1 MiB |
Quantile statistics
| Minimum | 24.89 |
|---|---|
| 5-th percentile | 268.358 |
| Q1 | 1260.2175 |
| median | 2495.195 |
| Q3 | 3731.845 |
| 95-th percentile | 4721.22 |
| Maximum | 4987.37 |
| Range | 4962.48 |
| Interquartile range (IQR) | 2471.6275 |
Descriptive statistics
| Standard deviation | 1426.9339 |
|---|---|
| Coefficient of variation (CV) | 0.57155383 |
| Kurtosis | -1.1973898 |
| Mean | 2496.5871 |
| Median Absolute Deviation (MAD) | 1235.585 |
| Skewness | 0.00028834919 |
| Sum | 3.1519412 × 108 |
| Variance | 2036140.4 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 2897.74 | 5 | < 0.1% |
| 3385.57 | 5 | < 0.1% |
| 3300.21 | 5 | < 0.1% |
| 4796.47 | 5 | < 0.1% |
| 3598.04 | 4 | < 0.1% |
| 4285.42 | 4 | < 0.1% |
| 1161.27 | 4 | < 0.1% |
| 1456.09 | 4 | < 0.1% |
| 2408.8 | 4 | < 0.1% |
| 3891.57 | 4 | < 0.1% |
| Other values (112409) | 126206 | |
| (Missing) | 15000 | 10.6% |
| Value | Count | Frequency (%) |
| 24.89 | 1 | |
| 24.96 | 1 | |
| 25.1 | 1 | |
| 25.12 | 1 | |
| 25.22 | 1 | |
| 25.23 | 1 | |
| 25.26 | 1 | |
| 25.28 | 1 | |
| 25.31 | 2 | |
| 25.34 | 1 |
| Value | Count | Frequency (%) |
| 4987.37 | 1 | |
| 4987.35 | 1 | |
| 4987.11 | 1 | |
| 4987.04 | 1 | |
| 4986.94 | 1 | |
| 4986.78 | 2 | |
| 4986.68 | 1 | |
| 4986.35 | 1 | |
| 4986.34 | 1 | |
| 4986.23 | 1 |
GW_Trx_Date
Date
Missing 
| Distinct | 90 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 15000 |
| Missing (%) | 10.6% |
| Memory size | 1.1 MiB |
| Minimum | 2025-01-01 00:00:00 |
|---|---|
| Maximum | 2025-03-31 00:00:00 |
| Invalid dates | 0 |
| Invalid dates (%) | 0.0% |
GW_Ref_Number
Text
Missing 
| Distinct | 125000 |
|---|---|
| Distinct (%) | 99.0% |
| Missing | 15000 |
| Missing (%) | 10.6% |
| Memory size | 7.7 MiB |
Length
| Max length | 11 |
|---|---|
| Median length | 11 |
| Mean length | 11 |
| Min length | 11 |
Unique
| Unique | 123750 ? |
|---|---|
| Unique (%) | 98.0% |
Sample
| 1st row | PAY-0000000 |
|---|---|
| 2nd row | PAY-0000001 |
| 3rd row | PAY-0000002 |
| 4th row | PAY-0000003 |
| 5th row | PAY-0000004 |
| Value | Count | Frequency (%) |
| pay-0118884 | 2 | < 0.1% |
| pay-0110496 | 2 | < 0.1% |
| pay-0015196 | 2 | < 0.1% |
| pay-0046112 | 2 | < 0.1% |
| pay-0046204 | 2 | < 0.1% |
| pay-0110180 | 2 | < 0.1% |
| pay-0077288 | 2 | < 0.1% |
| pay-0077050 | 2 | < 0.1% |
| pay-0079924 | 2 | < 0.1% |
| pay-0048439 | 2 | < 0.1% |
| Other values (124990) | 126230 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 298496 | |
| P | 126250 | |
| A | 126250 | |
| Y | 126250 | |
| - | 126250 | |
| 1 | 96397 | 6.9% |
| 2 | 66100 | 4.8% |
| 4 | 61140 | 4.4% |
| 3 | 61114 | 4.4% |
| 8 | 60139 | 4.3% |
| Other values (4) | 240364 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1388750 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 298496 | |
| P | 126250 | |
| A | 126250 | |
| Y | 126250 | |
| - | 126250 | |
| 1 | 96397 | 6.9% |
| 2 | 66100 | 4.8% |
| 4 | 61140 | 4.4% |
| 3 | 61114 | 4.4% |
| 8 | 60139 | 4.3% |
| Other values (4) | 240364 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1388750 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 298496 | |
| P | 126250 | |
| A | 126250 | |
| Y | 126250 | |
| - | 126250 | |
| 1 | 96397 | 6.9% |
| 2 | 66100 | 4.8% |
| 4 | 61140 | 4.4% |
| 3 | 61114 | 4.4% |
| 8 | 60139 | 4.3% |
| Other values (4) | 240364 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1388750 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 298496 | |
| P | 126250 | |
| A | 126250 | |
| Y | 126250 | |
| - | 126250 | |
| 1 | 96397 | 6.9% |
| 2 | 66100 | 4.8% |
| 4 | 61140 | 4.4% |
| 3 | 61114 | 4.4% |
| 8 | 60139 | 4.3% |
| Other values (4) | 240364 |
BS_GW_Match
Boolean
High correlation  Imbalance 
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 138.1 KiB |
| True | |
|---|---|
| False |
| Value | Count | Frequency (%) |
| True | 126250 | |
| False | 15000 | 10.6% |
MP_Trx_ID
Text
Missing 
| Distinct | 124946 |
|---|---|
| Distinct (%) | > 99.9% |
| Missing | 16250 |
| Missing (%) | 11.5% |
| Memory size | 8.4 MiB |
Length
| Max length | 17 |
|---|---|
| Median length | 17 |
| Mean length | 17 |
| Min length | 17 |
Unique
| Unique | 124892 ? |
|---|---|
| Unique (%) | 99.9% |
Sample
| 1st row | PROC-TRX-96148747 |
|---|---|
| 2nd row | PROC-TRX-53756634 |
| 3rd row | PROC-TRX-96643401 |
| 4th row | PROC-TRX-48503361 |
| 5th row | PROC-TRX-87613870 |
| Value | Count | Frequency (%) |
| proc-trx-20751798 | 2 | < 0.1% |
| proc-trx-47008295 | 2 | < 0.1% |
| proc-trx-18122493 | 2 | < 0.1% |
| proc-trx-77205797 | 2 | < 0.1% |
| proc-trx-72429823 | 2 | < 0.1% |
| proc-trx-59325275 | 2 | < 0.1% |
| proc-trx-28064569 | 2 | < 0.1% |
| proc-trx-77635747 | 2 | < 0.1% |
| proc-trx-93071076 | 2 | < 0.1% |
| proc-trx-76043245 | 2 | < 0.1% |
| Other values (124936) | 124980 |
Most occurring characters
| Value | Count | Frequency (%) |
| - | 250000 | 11.8% |
| R | 250000 | 11.8% |
| P | 125000 | 5.9% |
| O | 125000 | 5.9% |
| C | 125000 | 5.9% |
| T | 125000 | 5.9% |
| X | 125000 | 5.9% |
| 4 | 101764 | 4.8% |
| 8 | 101637 | 4.8% |
| 2 | 101575 | 4.8% |
| Other values (7) | 695024 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 2125000 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| - | 250000 | 11.8% |
| R | 250000 | 11.8% |
| P | 125000 | 5.9% |
| O | 125000 | 5.9% |
| C | 125000 | 5.9% |
| T | 125000 | 5.9% |
| X | 125000 | 5.9% |
| 4 | 101764 | 4.8% |
| 8 | 101637 | 4.8% |
| 2 | 101575 | 4.8% |
| Other values (7) | 695024 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 2125000 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| - | 250000 | 11.8% |
| R | 250000 | 11.8% |
| P | 125000 | 5.9% |
| O | 125000 | 5.9% |
| C | 125000 | 5.9% |
| T | 125000 | 5.9% |
| X | 125000 | 5.9% |
| 4 | 101764 | 4.8% |
| 8 | 101637 | 4.8% |
| 2 | 101575 | 4.8% |
| Other values (7) | 695024 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 2125000 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| - | 250000 | 11.8% |
| R | 250000 | 11.8% |
| P | 125000 | 5.9% |
| O | 125000 | 5.9% |
| C | 125000 | 5.9% |
| T | 125000 | 5.9% |
| X | 125000 | 5.9% |
| 4 | 101764 | 4.8% |
| 8 | 101637 | 4.8% |
| 2 | 101575 | 4.8% |
| Other values (7) | 695024 |
MP_Processor_Type
Categorical
High correlation  Missing 
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 16250 |
| Missing (%) | 11.5% |
| Memory size | 7.7 MiB |
| PayPal | |
|---|---|
| GoCardless | |
| ClientLine | |
| Amex |
Length
| Max length | 10 |
|---|---|
| Median length | 10 |
| Mean length | 8.000464 |
| Min length | 4 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | PayPal |
|---|---|
| 2nd row | GoCardless |
| 3rd row | GoCardless |
| 4th row | ClientLine |
| 5th row | PayPal |
Common Values
| Value | Count | Frequency (%) |
| PayPal | 41715 | |
| GoCardless | 41514 | |
| ClientLine | 27924 | |
| Amex | 13847 | 9.8% |
| (Missing) | 16250 | 11.5% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| paypal | 41715 | |
| gocardless | 41514 | |
| clientline | 27924 | |
| amex | 13847 | 11.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 124944 | |
| e | 111209 | |
| l | 111153 | |
| P | 83430 | 8.3% |
| s | 83028 | 8.3% |
| C | 69438 | 6.9% |
| i | 55848 | 5.6% |
| n | 55848 | 5.6% |
| y | 41715 | 4.2% |
| G | 41514 | 4.2% |
| Other values (8) | 221931 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1000058 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| a | 124944 | |
| e | 111209 | |
| l | 111153 | |
| P | 83430 | 8.3% |
| s | 83028 | 8.3% |
| C | 69438 | 6.9% |
| i | 55848 | 5.6% |
| n | 55848 | 5.6% |
| y | 41715 | 4.2% |
| G | 41514 | 4.2% |
| Other values (8) | 221931 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1000058 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| a | 124944 | |
| e | 111209 | |
| l | 111153 | |
| P | 83430 | 8.3% |
| s | 83028 | 8.3% |
| C | 69438 | 6.9% |
| i | 55848 | 5.6% |
| n | 55848 | 5.6% |
| y | 41715 | 4.2% |
| G | 41514 | 4.2% |
| Other values (8) | 221931 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1000058 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| a | 124944 | |
| e | 111209 | |
| l | 111153 | |
| P | 83430 | 8.3% |
| s | 83028 | 8.3% |
| C | 69438 | 6.9% |
| i | 55848 | 5.6% |
| n | 55848 | 5.6% |
| y | 41715 | 4.2% |
| G | 41514 | 4.2% |
| Other values (8) | 221931 |
MP_Trx_Type
Categorical
Constant  Missing 
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 16250 |
| Missing (%) | 11.5% |
| Memory size | 7.5 MiB |
| payment |
|---|
Length
| Max length | 7 |
|---|---|
| Median length | 7 |
| Mean length | 7 |
| Min length | 7 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | payment |
|---|---|
| 2nd row | payment |
| 3rd row | payment |
| 4th row | payment |
| 5th row | payment |
Common Values
| Value | Count | Frequency (%) |
| payment | 125000 | |
| (Missing) | 16250 | 11.5% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| payment | 125000 |
Most occurring characters
| Value | Count | Frequency (%) |
| p | 125000 | |
| a | 125000 | |
| y | 125000 | |
| m | 125000 | |
| e | 125000 | |
| n | 125000 | |
| t | 125000 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 875000 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| p | 125000 | |
| a | 125000 | |
| y | 125000 | |
| m | 125000 | |
| e | 125000 | |
| n | 125000 | |
| t | 125000 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 875000 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| p | 125000 | |
| a | 125000 | |
| y | 125000 | |
| m | 125000 | |
| e | 125000 | |
| n | 125000 | |
| t | 125000 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 875000 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| p | 125000 | |
| a | 125000 | |
| y | 125000 | |
| m | 125000 | |
| e | 125000 | |
| n | 125000 | |
| t | 125000 |
MP_Processor_Fee
Real number (ℝ)
High correlation  Missing  Zeros 
| Distinct | 7087 |
|---|---|
| Distinct (%) | 5.7% |
| Missing | 16250 |
| Missing (%) | 11.5% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 9.7874818 |
| Minimum | 0 |
|---|---|
| Maximum | 74.99 |
| Zeros | 83229 |
| Zeros (%) | 58.9% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.1 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 14.34 |
| 95-th percentile | 47.96 |
| Maximum | 74.99 |
| Range | 74.99 |
| Interquartile range (IQR) | 14.34 |
Descriptive statistics
| Standard deviation | 17.322844 |
|---|---|
| Coefficient of variation (CV) | 1.769898 |
| Kurtosis | 2.0055467 |
| Mean | 9.7874818 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 1.7338711 |
| Sum | 1223435.2 |
| Variance | 300.08092 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 83229 | |
| 28.66 | 18 | < 0.1% |
| 17.38 | 18 | < 0.1% |
| 20.4 | 18 | < 0.1% |
| 12.85 | 18 | < 0.1% |
| 49.61 | 18 | < 0.1% |
| 22.71 | 17 | < 0.1% |
| 25.57 | 17 | < 0.1% |
| 15.22 | 17 | < 0.1% |
| 2.85 | 17 | < 0.1% |
| Other values (7077) | 41613 | |
| (Missing) | 16250 | 11.5% |
| Value | Count | Frequency (%) |
| 0 | 83229 | |
| 0.26 | 5 | < 0.1% |
| 0.27 | 9 | < 0.1% |
| 0.28 | 7 | < 0.1% |
| 0.29 | 3 | < 0.1% |
| 0.3 | 9 | < 0.1% |
| 0.31 | 2 | < 0.1% |
| 0.32 | 4 | < 0.1% |
| 0.33 | 6 | < 0.1% |
| 0.34 | 3 | < 0.1% |
| Value | Count | Frequency (%) |
| 74.99 | 1 | < 0.1% |
| 74.98 | 3 | |
| 74.97 | 2 | |
| 74.95 | 2 | |
| 74.94 | 4 | |
| 74.93 | 3 | |
| 74.92 | 1 | < 0.1% |
| 74.91 | 1 | < 0.1% |
| 74.9 | 2 | |
| 74.89 | 2 |
MP_Settled_Amount
Real number (ℝ)
High correlation  Missing 
| Distinct | 113685 |
|---|---|
| Distinct (%) | 90.9% |
| Missing | 16250 |
| Missing (%) | 11.5% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2486.9651 |
| Minimum | 24.84 |
|---|---|
| Maximum | 4987.37 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.1 MiB |
Quantile statistics
| Minimum | 24.84 |
|---|---|
| 5-th percentile | 267.5695 |
| Q1 | 1255.88 |
| median | 2486.03 |
| Q3 | 3715.785 |
| 95-th percentile | 4704.0705 |
| Maximum | 4987.37 |
| Range | 4962.53 |
| Interquartile range (IQR) | 2459.905 |
Descriptive statistics
| Standard deviation | 1421.6569 |
|---|---|
| Coefficient of variation (CV) | 0.57164327 |
| Kurtosis | -1.1966635 |
| Mean | 2486.9651 |
| Median Absolute Deviation (MAD) | 1230.085 |
| Skewness | 0.0010518471 |
| Sum | 3.1087064 × 108 |
| Variance | 2021108.2 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 3598.04 | 5 | < 0.1% |
| 398.52 | 5 | < 0.1% |
| 513 | 4 | < 0.1% |
| 3612.01 | 4 | < 0.1% |
| 257.12 | 4 | < 0.1% |
| 2602.42 | 4 | < 0.1% |
| 3613.72 | 4 | < 0.1% |
| 1660.32 | 4 | < 0.1% |
| 4664.19 | 4 | < 0.1% |
| 1439.83 | 4 | < 0.1% |
| Other values (113675) | 124958 | |
| (Missing) | 16250 | 11.5% |
| Value | Count | Frequency (%) |
| 24.84 | 1 | |
| 24.85 | 1 | |
| 24.89 | 1 | |
| 24.96 | 1 | |
| 25.1 | 1 | |
| 25.11 | 1 | |
| 25.12 | 1 | |
| 25.26 | 1 | |
| 25.28 | 1 | |
| 25.31 | 2 |
| Value | Count | Frequency (%) |
| 4987.37 | 1 | |
| 4987.35 | 1 | |
| 4987.11 | 1 | |
| 4987.04 | 1 | |
| 4986.94 | 1 | |
| 4986.78 | 2 | |
| 4986.68 | 1 | |
| 4986.35 | 1 | |
| 4986.34 | 1 | |
| 4986.23 | 1 |
Missing 
| Distinct | 65 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 16250 |
| Missing (%) | 11.5% |
| Memory size | 1.1 MiB |
| Minimum | 2025-01-02 00:00:00 |
|---|---|
| Maximum | 2025-04-02 00:00:00 |
| Invalid dates | 0 |
| Invalid dates (%) | 0.0% |
Missing 
| Distinct | 2250 |
|---|---|
| Distinct (%) | 1.8% |
| Missing | 16250 |
| Missing (%) | 11.5% |
| Memory size | 9.9 MiB |
Length
| Max length | 38 |
|---|---|
| Median length | 32 |
| Mean length | 30.010328 |
| Min length | 26 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | SET-20250130-PayPal-N/A-USD |
|---|---|
| 2nd row | SET-20250110-GoCardless-N/A-USD |
| 3rd row | SET-20250221-GoCardless-N/A-USD |
| 4th row | SET-20250104-ClientLine-Visa-GBP |
| 5th row | SET-20250316-PayPal-N/A-USD |
| Value | Count | Frequency (%) |
| set-20250120-paypal-n/a-usd | 318 | 0.3% |
| set-20250202-paypal-n/a-usd | 316 | 0.3% |
| set-20250316-paypal-n/a-usd | 311 | 0.2% |
| set-20250210-gocardless-n/a-usd | 311 | 0.2% |
| set-20250313-gocardless-n/a-usd | 311 | 0.2% |
| set-20250102-paypal-n/a-usd | 310 | 0.2% |
| set-20250112-paypal-n/a-usd | 309 | 0.2% |
| set-20250121-paypal-n/a-usd | 309 | 0.2% |
| set-20250101-paypal-n/a-usd | 308 | 0.2% |
| set-20250214-paypal-n/a-usd | 307 | 0.2% |
| Other values (2240) | 121890 |
Most occurring characters
| Value | Count | Frequency (%) |
| - | 500000 | 13.3% |
| 2 | 341956 | 9.1% |
| 0 | 298474 | 8.0% |
| S | 200092 | 5.3% |
| a | 166945 | 4.5% |
| E | 143598 | 3.8% |
| e | 139133 | 3.7% |
| 5 | 137569 | 3.7% |
| A | 129778 | 3.5% |
| T | 125000 | 3.3% |
| Other values (31) | 1568746 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 3751291 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| - | 500000 | 13.3% |
| 2 | 341956 | 9.1% |
| 0 | 298474 | 8.0% |
| S | 200092 | 5.3% |
| a | 166945 | 4.5% |
| E | 143598 | 3.8% |
| e | 139133 | 3.7% |
| 5 | 137569 | 3.7% |
| A | 129778 | 3.5% |
| T | 125000 | 3.3% |
| Other values (31) | 1568746 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 3751291 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| - | 500000 | 13.3% |
| 2 | 341956 | 9.1% |
| 0 | 298474 | 8.0% |
| S | 200092 | 5.3% |
| a | 166945 | 4.5% |
| E | 143598 | 3.8% |
| e | 139133 | 3.7% |
| 5 | 137569 | 3.7% |
| A | 129778 | 3.5% |
| T | 125000 | 3.3% |
| Other values (31) | 1568746 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 3751291 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| - | 500000 | 13.3% |
| 2 | 341956 | 9.1% |
| 0 | 298474 | 8.0% |
| S | 200092 | 5.3% |
| a | 166945 | 4.5% |
| E | 143598 | 3.8% |
| e | 139133 | 3.7% |
| 5 | 137569 | 3.7% |
| A | 129778 | 3.5% |
| T | 125000 | 3.3% |
| Other values (31) | 1568746 |
MP_Trx_Currency
Categorical
High correlation  Missing 
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 16250 |
| Missing (%) | 11.5% |
| Memory size | 7.1 MiB |
| USD | |
|---|---|
| EUR | |
| GBP | |
| AUD | |
| CAD |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | USD |
|---|---|
| 2nd row | USD |
| 3rd row | USD |
| 4th row | GBP |
| 5th row | USD |
Common Values
| Value | Count | Frequency (%) |
| USD | 75092 | |
| EUR | 18598 | 13.2% |
| GBP | 12455 | 8.8% |
| AUD | 10059 | 7.1% |
| CAD | 8796 | 6.2% |
| (Missing) | 16250 | 11.5% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| usd | 75092 | |
| eur | 18598 | 14.9% |
| gbp | 12455 | 10.0% |
| aud | 10059 | 8.0% |
| cad | 8796 | 7.0% |
Most occurring characters
| Value | Count | Frequency (%) |
| U | 103749 | |
| D | 93947 | |
| S | 75092 | |
| A | 18855 | 5.0% |
| E | 18598 | 5.0% |
| R | 18598 | 5.0% |
| G | 12455 | 3.3% |
| B | 12455 | 3.3% |
| P | 12455 | 3.3% |
| C | 8796 | 2.3% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 375000 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| U | 103749 | |
| D | 93947 | |
| S | 75092 | |
| A | 18855 | 5.0% |
| E | 18598 | 5.0% |
| R | 18598 | 5.0% |
| G | 12455 | 3.3% |
| B | 12455 | 3.3% |
| P | 12455 | 3.3% |
| C | 8796 | 2.3% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 375000 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| U | 103749 | |
| D | 93947 | |
| S | 75092 | |
| A | 18855 | 5.0% |
| E | 18598 | 5.0% |
| R | 18598 | 5.0% |
| G | 12455 | 3.3% |
| B | 12455 | 3.3% |
| P | 12455 | 3.3% |
| C | 8796 | 2.3% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 375000 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| U | 103749 | |
| D | 93947 | |
| S | 75092 | |
| A | 18855 | 5.0% |
| E | 18598 | 5.0% |
| R | 18598 | 5.0% |
| G | 12455 | 3.3% |
| B | 12455 | 3.3% |
| P | 12455 | 3.3% |
| C | 8796 | 2.3% |
MP_Order_ID
Text
Missing 
| Distinct | 125000 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 16250 |
| Missing (%) | 11.5% |
| Memory size | 7.6 MiB |
Length
| Max length | 11 |
|---|---|
| Median length | 11 |
| Mean length | 11 |
| Min length | 11 |
Unique
| Unique | 125000 ? |
|---|---|
| Unique (%) | 100.0% |
Sample
| 1st row | PAY-0000000 |
|---|---|
| 2nd row | PAY-0000001 |
| 3rd row | PAY-0000002 |
| 4th row | PAY-0000003 |
| 5th row | PAY-0000004 |
| Value | Count | Frequency (%) |
| pay-0083344 | 1 | < 0.1% |
| pay-0000002 | 1 | < 0.1% |
| pay-0000004 | 1 | < 0.1% |
| pay-0000005 | 1 | < 0.1% |
| pay-0000006 | 1 | < 0.1% |
| pay-0000007 | 1 | < 0.1% |
| pay-0000008 | 1 | < 0.1% |
| pay-0000009 | 1 | < 0.1% |
| pay-0000010 | 1 | < 0.1% |
| pay-0000011 | 1 | < 0.1% |
| Other values (124990) | 124990 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 295500 | |
| P | 125000 | |
| A | 125000 | |
| Y | 125000 | |
| - | 125000 | |
| 1 | 95500 | 6.9% |
| 2 | 65500 | 4.8% |
| 3 | 60500 | 4.4% |
| 4 | 60500 | 4.4% |
| 8 | 59500 | 4.3% |
| Other values (4) | 238000 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1375000 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 295500 | |
| P | 125000 | |
| A | 125000 | |
| Y | 125000 | |
| - | 125000 | |
| 1 | 95500 | 6.9% |
| 2 | 65500 | 4.8% |
| 3 | 60500 | 4.4% |
| 4 | 60500 | 4.4% |
| 8 | 59500 | 4.3% |
| Other values (4) | 238000 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1375000 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 295500 | |
| P | 125000 | |
| A | 125000 | |
| Y | 125000 | |
| - | 125000 | |
| 1 | 95500 | 6.9% |
| 2 | 65500 | 4.8% |
| 3 | 60500 | 4.4% |
| 4 | 60500 | 4.4% |
| 8 | 59500 | 4.3% |
| Other values (4) | 238000 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1375000 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 295500 | |
| P | 125000 | |
| A | 125000 | |
| Y | 125000 | |
| - | 125000 | |
| 1 | 95500 | 6.9% |
| 2 | 65500 | 4.8% |
| 3 | 60500 | 4.4% |
| 4 | 60500 | 4.4% |
| 8 | 59500 | 4.3% |
| Other values (4) | 238000 |
PG_MP_Match
Boolean
High correlation 
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 138.1 KiB |
| True | |
|---|---|
| False |
| Value | Count | Frequency (%) |
| True | 125000 | |
| False | 16250 | 11.5% |
Missing 
| Distinct | 63 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 20362 |
| Missing (%) | 14.4% |
| Memory size | 1.1 MiB |
| Minimum | 2025-01-03 00:00:00 |
|---|---|
| Maximum | 2025-04-01 00:00:00 |
| Invalid dates | 0 |
| Invalid dates (%) | 0.0% |
Bank_Deposit_Currency
Categorical
High correlation  Missing 
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 20362 |
| Missing (%) | 14.4% |
| Memory size | 7.1 MiB |
| USD | |
|---|---|
| EUR | |
| GBP | |
| AUD | |
| CAD |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | USD |
|---|---|
| 2nd row | USD |
| 3rd row | USD |
| 4th row | GBP |
| 5th row | USD |
Common Values
| Value | Count | Frequency (%) |
| USD | 72643 | |
| EUR | 17956 | 12.7% |
| GBP | 12059 | 8.5% |
| AUD | 9725 | 6.9% |
| CAD | 8505 | 6.0% |
| (Missing) | 20362 | 14.4% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| usd | 72643 | |
| eur | 17956 | 14.9% |
| gbp | 12059 | 10.0% |
| aud | 9725 | 8.0% |
| cad | 8505 | 7.0% |
Most occurring characters
| Value | Count | Frequency (%) |
| U | 100324 | |
| D | 90873 | |
| S | 72643 | |
| A | 18230 | 5.0% |
| E | 17956 | 5.0% |
| R | 17956 | 5.0% |
| G | 12059 | 3.3% |
| B | 12059 | 3.3% |
| P | 12059 | 3.3% |
| C | 8505 | 2.3% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 362664 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| U | 100324 | |
| D | 90873 | |
| S | 72643 | |
| A | 18230 | 5.0% |
| E | 17956 | 5.0% |
| R | 17956 | 5.0% |
| G | 12059 | 3.3% |
| B | 12059 | 3.3% |
| P | 12059 | 3.3% |
| C | 8505 | 2.3% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 362664 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| U | 100324 | |
| D | 90873 | |
| S | 72643 | |
| A | 18230 | 5.0% |
| E | 17956 | 5.0% |
| R | 17956 | 5.0% |
| G | 12059 | 3.3% |
| B | 12059 | 3.3% |
| P | 12059 | 3.3% |
| C | 8505 | 2.3% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 362664 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| U | 100324 | |
| D | 90873 | |
| S | 72643 | |
| A | 18230 | 5.0% |
| E | 17956 | 5.0% |
| R | 17956 | 5.0% |
| G | 12059 | 3.3% |
| B | 12059 | 3.3% |
| P | 12059 | 3.3% |
| C | 8505 | 2.3% |
Missing 
| Distinct | 2175 |
|---|---|
| Distinct (%) | 1.8% |
| Missing | 20362 |
| Missing (%) | 14.4% |
| Memory size | 9.7 MiB |
Length
| Max length | 38 |
|---|---|
| Median length | 32 |
| Mean length | 30.008669 |
| Min length | 26 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | SET-20250130-PayPal-N/A-USD |
|---|---|
| 2nd row | SET-20250110-GoCardless-N/A-USD |
| 3rd row | SET-20250221-GoCardless-N/A-USD |
| 4th row | SET-20250104-ClientLine-Visa-GBP |
| 5th row | SET-20250316-PayPal-N/A-USD |
| Value | Count | Frequency (%) |
| set-20250120-paypal-n/a-usd | 318 | 0.3% |
| set-20250202-paypal-n/a-usd | 316 | 0.3% |
| set-20250313-gocardless-n/a-usd | 311 | 0.3% |
| set-20250210-gocardless-n/a-usd | 311 | 0.3% |
| set-20250316-paypal-n/a-usd | 311 | 0.3% |
| set-20250102-paypal-n/a-usd | 310 | 0.3% |
| set-20250112-paypal-n/a-usd | 309 | 0.3% |
| set-20250121-paypal-n/a-usd | 309 | 0.3% |
| set-20250101-paypal-n/a-usd | 308 | 0.3% |
| set-20250214-paypal-n/a-usd | 307 | 0.3% |
| Other values (2165) | 117778 |
Most occurring characters
| Value | Count | Frequency (%) |
| - | 483552 | 13.3% |
| 2 | 332380 | 9.2% |
| 0 | 288873 | 8.0% |
| S | 193531 | 5.3% |
| a | 161527 | 4.5% |
| E | 138844 | 3.8% |
| e | 134480 | 3.7% |
| 5 | 133457 | 3.7% |
| A | 125490 | 3.5% |
| T | 120888 | 3.3% |
| Other values (31) | 1514666 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 3627688 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| - | 483552 | 13.3% |
| 2 | 332380 | 9.2% |
| 0 | 288873 | 8.0% |
| S | 193531 | 5.3% |
| a | 161527 | 4.5% |
| E | 138844 | 3.8% |
| e | 134480 | 3.7% |
| 5 | 133457 | 3.7% |
| A | 125490 | 3.5% |
| T | 120888 | 3.3% |
| Other values (31) | 1514666 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 3627688 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| - | 483552 | 13.3% |
| 2 | 332380 | 9.2% |
| 0 | 288873 | 8.0% |
| S | 193531 | 5.3% |
| a | 161527 | 4.5% |
| E | 138844 | 3.8% |
| e | 134480 | 3.7% |
| 5 | 133457 | 3.7% |
| A | 125490 | 3.5% |
| T | 120888 | 3.3% |
| Other values (31) | 1514666 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 3627688 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| - | 483552 | 13.3% |
| 2 | 332380 | 9.2% |
| 0 | 288873 | 8.0% |
| S | 193531 | 5.3% |
| a | 161527 | 4.5% |
| E | 138844 | 3.8% |
| e | 134480 | 3.7% |
| 5 | 133457 | 3.7% |
| A | 125490 | 3.5% |
| T | 120888 | 3.3% |
| Other values (31) | 1514666 |
Bank_Credits
Real number (ℝ)
High correlation  Missing 
| Distinct | 2175 |
|---|---|
| Distinct (%) | 1.8% |
| Missing | 20362 |
| Missing (%) | 14.4% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 325334.82 |
| Minimum | 5028.22 |
|---|---|
| Maximum | 749550.42 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.1 MiB |
Quantile statistics
| Minimum | 5028.22 |
|---|---|
| 5-th percentile | 32212.59 |
| Q1 | 100151.47 |
| median | 205686.24 |
| Q3 | 604922.26 |
| 95-th percentile | 677149.72 |
| Maximum | 749550.42 |
| Range | 744522.2 |
| Interquartile range (IQR) | 504770.79 |
Descriptive statistics
| Standard deviation | 249719.87 |
|---|---|
| Coefficient of variation (CV) | 0.76757805 |
| Kurtosis | -1.6789828 |
| Mean | 325334.82 |
| Median Absolute Deviation (MAD) | 157108.97 |
| Skewness | 0.31218339 |
| Sum | 3.9329076 × 1010 |
| Variance | 6.2360012 × 1010 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 749550.42 | 318 | 0.2% |
| 652986.91 | 316 | 0.2% |
| 697204.32 | 311 | 0.2% |
| 681556.78 | 311 | 0.2% |
| 709519.97 | 311 | 0.2% |
| 651192.52 | 310 | 0.2% |
| 684456.26 | 309 | 0.2% |
| 695829.1 | 309 | 0.2% |
| 678343.79 | 308 | 0.2% |
| 684766.63 | 307 | 0.2% |
| Other values (2165) | 117778 | |
| (Missing) | 20362 | 14.4% |
| Value | Count | Frequency (%) |
| 5028.22 | 4 | |
| 5239.3 | 6 | |
| 5700.37 | 7 | |
| 5851.66 | 3 | < 0.1% |
| 6105.74 | 5 | |
| 6537.55 | 4 | |
| 7265.99 | 4 | |
| 7395.72 | 9 | |
| 8551.64 | 4 | |
| 8736.6 | 6 |
| Value | Count | Frequency (%) |
| 749550.42 | 318 | |
| 711543.33 | 301 | |
| 709519.97 | 311 | |
| 708968.47 | 289 | |
| 701886.7 | 302 | |
| 701471.09 | 305 | |
| 700747.49 | 296 | |
| 697204.32 | 311 | |
| 696299.76 | 292 | |
| 695829.1 | 309 |
Bank_Debits
Categorical
Constant  Missing 
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 20362 |
| Missing (%) | 14.4% |
| Memory size | 7.1 MiB |
| 0.0 |
|---|
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0.0 |
|---|---|
| 2nd row | 0.0 |
| 3rd row | 0.0 |
| 4th row | 0.0 |
| 5th row | 0.0 |
Common Values
| Value | Count | Frequency (%) |
| 0.0 | 120888 | |
| (Missing) | 20362 | 14.4% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0.0 | 120888 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 241776 | |
| . | 120888 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 362664 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 241776 | |
| . | 120888 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 362664 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 241776 | |
| . | 120888 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 362664 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 241776 | |
| . | 120888 |
end_to_end_recon_match
Boolean
High correlation 
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 138.1 KiB |
| True | |
|---|---|
| False |
| Value | Count | Frequency (%) |
| True | 120888 | |
| False | 20362 | 14.4% |
Interactions
Correlations
| BS_Amount | BS_Card_Type | BS_Currency | BS_Foreign_Exchange_Rate | BS_GW_Match | BS_Payment_Gateway | BS_Payment_Method_Type | BS_Processor_Response_Message | BS_Record_Type | BS_Sales_Channel | Bank_Credits | Bank_Deposit_Currency | GW_Card_Brand | GW_Net_Settled_Amt | GW_Transaction_Amount | GW_Trx_Currency | GW_fees | GW_name | MP_Processor_Fee | MP_Processor_Type | MP_Settled_Amount | MP_Trx_Currency | PG_MP_Match | end_to_end_recon_match | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| BS_Amount | 1.000 | 0.003 | 0.004 | -0.003 | 1.000 | 0.000 | 0.000 | 0.577 | 0.577 | 0.003 | 0.012 | 0.002 | 0.003 | 1.000 | 1.000 | 0.002 | 0.760 | 0.000 | 0.126 | 0.000 | 1.000 | 0.002 | 0.956 | 0.840 |
| BS_Card_Type | 0.003 | 1.000 | 0.002 | 0.002 | 0.000 | 1.000 | 1.000 | 0.000 | 0.000 | 0.000 | 0.404 | 0.000 | 1.000 | 0.006 | 0.003 | 0.000 | 0.359 | 1.000 | 0.510 | 1.000 | 0.013 | 0.000 | 0.000 | 0.000 |
| BS_Currency | 0.004 | 0.002 | 1.000 | 1.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.489 | 1.000 | 0.000 | 0.003 | 0.004 | 1.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.003 | 1.000 | 0.000 | 0.000 |
| BS_Foreign_Exchange_Rate | -0.003 | 0.002 | 1.000 | 1.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | -0.090 | 1.000 | 0.000 | -0.007 | -0.007 | 1.000 | -0.004 | 0.000 | -0.001 | 0.000 | -0.006 | 1.000 | 0.000 | 0.000 |
| BS_GW_Match | 1.000 | 0.000 | 0.000 | 0.000 | 1.000 | 0.000 | 0.000 | 1.000 | 1.000 | 0.000 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 0.956 | 0.840 |
| BS_Payment_Gateway | 0.000 | 1.000 | 0.000 | 0.000 | 0.000 | 1.000 | 1.000 | 0.000 | 0.000 | 0.000 | 0.570 | 0.000 | 1.000 | 0.007 | 0.000 | 0.000 | 0.508 | 1.000 | 0.640 | 1.000 | 0.018 | 0.000 | 0.002 | 0.002 |
| BS_Payment_Method_Type | 0.000 | 1.000 | 0.000 | 0.000 | 0.000 | 1.000 | 1.000 | 0.000 | 0.000 | 0.000 | 0.570 | 0.000 | 1.000 | 0.007 | 0.000 | 0.000 | 0.508 | 1.000 | 0.640 | 1.000 | 0.018 | 0.000 | 0.002 | 0.002 |
| BS_Processor_Response_Message | 0.577 | 0.000 | 0.000 | 0.000 | 1.000 | 0.000 | 0.000 | 1.000 | 1.000 | 0.000 | 1.000 | 1.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.001 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 0.879 |
| BS_Record_Type | 0.577 | 0.000 | 0.000 | 0.000 | 1.000 | 0.000 | 0.000 | 1.000 | 1.000 | 0.000 | 1.000 | 1.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.001 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 0.879 |
| BS_Sales_Channel | 0.003 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 1.000 | 0.000 | 0.000 | 0.000 | 0.004 | 0.004 | 0.000 | 0.004 | 0.000 | 0.004 | 0.000 | 0.004 | 0.000 | 0.000 | 0.000 |
| Bank_Credits | 0.012 | 0.404 | 0.489 | -0.090 | 1.000 | 0.570 | 0.570 | 1.000 | 1.000 | 0.000 | 1.000 | 0.489 | 0.404 | 0.013 | 0.012 | 0.489 | -0.166 | 0.570 | -0.417 | 0.466 | 0.017 | 0.489 | 1.000 | 1.000 |
| Bank_Deposit_Currency | 0.002 | 0.000 | 1.000 | 1.000 | 1.000 | 0.000 | 0.000 | 1.000 | 1.000 | 0.000 | 0.489 | 1.000 | 0.000 | 0.001 | 0.002 | 1.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.002 | 1.000 | 1.000 | 1.000 |
| GW_Card_Brand | 0.003 | 1.000 | 0.000 | 0.000 | 1.000 | 1.000 | 1.000 | 0.000 | 0.000 | 0.000 | 0.404 | 0.000 | 1.000 | 0.006 | 0.003 | 0.000 | 0.359 | 1.000 | 0.510 | 1.000 | 0.013 | 0.000 | 0.000 | 0.002 |
| GW_Net_Settled_Amt | 1.000 | 0.006 | 0.003 | -0.007 | 1.000 | 0.007 | 0.007 | 0.000 | 0.000 | 0.004 | 0.013 | 0.001 | 0.006 | 1.000 | 1.000 | 0.003 | 0.756 | 0.007 | 0.122 | 0.006 | 1.000 | 0.003 | 0.000 | 0.000 |
| GW_Transaction_Amount | 1.000 | 0.003 | 0.004 | -0.007 | 1.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.004 | 0.012 | 0.002 | 0.003 | 1.000 | 1.000 | 0.004 | 0.760 | 0.000 | 0.126 | 0.000 | 1.000 | 0.004 | 0.000 | 0.000 |
| GW_Trx_Currency | 0.002 | 0.000 | 1.000 | 1.000 | 1.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.489 | 1.000 | 0.000 | 0.003 | 0.004 | 1.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.003 | 1.000 | 0.000 | 0.000 |
| GW_fees | 0.760 | 0.359 | 0.000 | -0.004 | 1.000 | 0.508 | 0.508 | 0.000 | 0.000 | 0.004 | -0.166 | 0.000 | 0.359 | 0.756 | 0.760 | 0.000 | 1.000 | 0.508 | 0.517 | 0.415 | 0.751 | 0.000 | 0.000 | 0.000 |
| GW_name | 0.000 | 1.000 | 0.000 | 0.000 | 1.000 | 1.000 | 1.000 | 0.001 | 0.001 | 0.000 | 0.570 | 0.000 | 1.000 | 0.007 | 0.000 | 0.000 | 0.508 | 1.000 | 0.640 | 1.000 | 0.018 | 0.000 | 0.001 | 0.004 |
| MP_Processor_Fee | 0.126 | 0.510 | 0.000 | -0.001 | 1.000 | 0.640 | 0.640 | 1.000 | 1.000 | 0.004 | -0.417 | 0.000 | 0.510 | 0.122 | 0.126 | 0.000 | 0.517 | 0.640 | 1.000 | 0.589 | 0.111 | 0.000 | 1.000 | 0.000 |
| MP_Processor_Type | 0.000 | 1.000 | 0.000 | 0.000 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 0.000 | 0.466 | 0.000 | 1.000 | 0.006 | 0.000 | 0.000 | 0.415 | 1.000 | 0.589 | 1.000 | 0.015 | 0.000 | 1.000 | 0.004 |
| MP_Settled_Amount | 1.000 | 0.013 | 0.003 | -0.006 | 1.000 | 0.018 | 0.018 | 1.000 | 1.000 | 0.004 | 0.017 | 0.002 | 0.013 | 1.000 | 1.000 | 0.003 | 0.751 | 0.018 | 0.111 | 0.015 | 1.000 | 0.003 | 1.000 | 0.000 |
| MP_Trx_Currency | 0.002 | 0.000 | 1.000 | 1.000 | 1.000 | 0.000 | 0.000 | 1.000 | 1.000 | 0.000 | 0.489 | 1.000 | 0.000 | 0.003 | 0.004 | 1.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.003 | 1.000 | 1.000 | 0.000 |
| PG_MP_Match | 0.956 | 0.000 | 0.000 | 0.000 | 0.956 | 0.002 | 0.002 | 1.000 | 1.000 | 0.000 | 1.000 | 1.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.001 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 0.878 |
| end_to_end_recon_match | 0.840 | 0.000 | 0.000 | 0.000 | 0.840 | 0.002 | 0.002 | 0.879 | 0.879 | 0.000 | 1.000 | 1.000 | 0.002 | 0.000 | 0.000 | 0.000 | 0.000 | 0.004 | 0.000 | 0.004 | 0.000 | 0.000 | 0.878 | 1.000 |
Missing values
Sample
| BS_Record_Type | BS_Transaction_Date | BS_Currency | BS_Customer_Number | BS_Amount | BS_Payment_Method_Type | BS_Card_Type | BS_Processor_Transaction_Id | BS_Payment_Gateway | BS_Processor_Response_Code | BS_Processor_Response_Message | BS_Inv_Payment_Number | BS_Sales_Channel | BS_Foreign_Exchange_Rate | GW_Transaction_ID | GW_name | GW_Transaction_Status | GW_Response_Code | GW_Response | GW_Transaction_Amount | GW_Trx_Currency | GW_Trx_Type | GW_Card_Brand | GW_fees | GW_Net_Settled_Amt | GW_Trx_Date | GW_Ref_Number | BS_GW_Match | MP_Trx_ID | MP_Processor_Type | MP_Trx_Type | MP_Processor_Fee | MP_Settled_Amount | MP_Settlement_Date | MP_Settlement_Batch | MP_Trx_Currency | MP_Order_ID | PG_MP_Match | Bank_Deposit_Date | Bank_Deposit_Currency | Bank_Deposit_Ref_Number | Bank_Credits | Bank_Debits | end_to_end_recon_match | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | payment | 2025-01-30 | USD | CUST15159 | 2592.98 | PayPal | PayPal | PROC-21233551 | PayPal | 0 | Approved | PAY-0000000 | In-Store | 1.0017 | GW-TRX-9972261 | PayPal | settled | 0 | Approved | 2592.98 | USD | payment | PayPal | 19.45 | 2573.53 | 2025-01-30 | PAY-0000000 | Yes | PROC-TRX-96148747 | PayPal | payment | 0.00 | 2573.53 | 2025-01-31 | SET-20250130-PayPal-N/A-USD | USD | PAY-0000000 | Yes | 2025-02-03 | USD | SET-20250130-PayPal-N/A-USD | 584871.77 | 0.0 | Yes |
| 1 | payment | 2025-01-10 | USD | CUST20779 | 4277.28 | ACH | ACH | PROC-45142454 | GoCardless | 0 | Approved | PAY-0000001 | In-Store | 1.0058 | GW-TRX-8455695 | GoCardless | settled | 0 | Approved | 4277.28 | USD | payment | GoCardless | 10.69 | 4266.59 | 2025-01-10 | PAY-0000001 | Yes | PROC-TRX-53756634 | GoCardless | payment | 0.00 | 4266.59 | 2025-01-13 | SET-20250110-GoCardless-N/A-USD | USD | PAY-0000001 | Yes | 2025-01-14 | USD | SET-20250110-GoCardless-N/A-USD | 621022.33 | 0.0 | Yes |
| 2 | payment | 2025-02-21 | USD | CUST28404 | 2515.78 | ACH | ACH | PROC-76309118 | GoCardless | 0 | Approved | PAY-0000002 | Phone | 1.0056 | GW-TRX-5184318 | GoCardless | settled | 0 | Approved | 2515.78 | USD | payment | GoCardless | 6.29 | 2509.49 | 2025-02-21 | PAY-0000002 | Yes | PROC-TRX-96643401 | GoCardless | payment | 0.00 | 2509.49 | 2025-02-24 | SET-20250221-GoCardless-N/A-USD | USD | PAY-0000002 | Yes | 2025-02-25 | USD | SET-20250221-GoCardless-N/A-USD | 655334.98 | 0.0 | Yes |
| 3 | payment | 2025-01-04 | GBP | CUST7007 | 2874.81 | Credit Card | Visa | PROC-62839998 | Cybersource | 0 | Approved | PAY-0000003 | Phone | 1.2599 | GW-TRX-8104962 | Cybersource | settled | 0 | Approved | 2874.81 | GBP | payment | Visa | 28.75 | 2846.06 | 2025-01-04 | PAY-0000003 | Yes | PROC-TRX-48503361 | ClientLine | payment | 28.75 | 2817.31 | 2025-01-07 | SET-20250104-ClientLine-Visa-GBP | GBP | PAY-0000003 | Yes | 2025-01-08 | GBP | SET-20250104-ClientLine-Visa-GBP | 38585.64 | 0.0 | Yes |
| 4 | payment | 2025-03-16 | USD | CUST39746 | 350.01 | PayPal | PayPal | PROC-62414033 | PayPal | 0 | Approved | PAY-0000004 | In-Store | 1.0060 | GW-TRX-2770667 | PayPal | settled | 0 | Approved | 350.01 | USD | payment | PayPal | 2.63 | 347.38 | 2025-03-16 | PAY-0000004 | Yes | PROC-TRX-87613870 | PayPal | payment | 0.00 | 347.38 | 2025-03-19 | SET-20250316-PayPal-N/A-USD | USD | PAY-0000004 | Yes | 2025-03-20 | USD | SET-20250316-PayPal-N/A-USD | 681556.78 | 0.0 | Yes |
| 5 | payment | 2025-02-10 | USD | CUST3055 | 4412.91 | Credit Card | Mastercard | PROC-58248354 | Cybersource | 0 | Approved | PAY-0000005 | Online | 1.0076 | GW-TRX-8558984 | Cybersource | settled | 0 | Approved | 4412.91 | USD | payment | Mastercard | 44.13 | 4368.78 | 2025-02-10 | PAY-0000005 | Yes | PROC-TRX-40189275 | ClientLine | payment | 44.13 | 4324.65 | 2025-02-11 | SET-20250210-ClientLine-Mastercard-USD | USD | PAY-0000005 | Yes | 2025-02-12 | USD | SET-20250210-ClientLine-Mastercard-USD | 138689.96 | 0.0 | Yes |
| 6 | payment | 2025-02-07 | AUD | CUST6360 | 399.15 | ACH | ACH | PROC-58711045 | GoCardless | 0 | Approved | PAY-0000006 | In-Store | 0.6555 | GW-TRX-5053867 | GoCardless | settled | 0 | Approved | 399.15 | AUD | payment | GoCardless | 1.00 | 398.15 | 2025-02-07 | PAY-0000006 | Yes | PROC-TRX-13724055 | GoCardless | payment | 0.00 | 398.15 | 2025-02-10 | SET-20250207-GoCardless-N/A-AUD | AUD | PAY-0000006 | Yes | 2025-02-11 | AUD | SET-20250207-GoCardless-N/A-AUD | 89870.35 | 0.0 | Yes |
| 7 | payment | 2025-02-20 | GBP | CUST44856 | 1639.12 | ACH | ACH | PROC-99846281 | GoCardless | 0 | Approved | PAY-0000007 | In-Store | 1.2759 | GW-TRX-1689560 | GoCardless | settled | 0 | Approved | 1639.12 | GBP | payment | GoCardless | 4.10 | 1635.02 | 2025-02-20 | PAY-0000007 | Yes | PROC-TRX-57320369 | GoCardless | payment | 0.00 | 1635.02 | 2025-02-21 | SET-20250220-GoCardless-N/A-GBP | GBP | PAY-0000007 | Yes | 2025-02-24 | GBP | SET-20250220-GoCardless-N/A-GBP | 71271.86 | 0.0 | Yes |
| 8 | payment | 2025-02-25 | USD | CUST8902 | 802.45 | Credit Card | Amex | PROC-65593396 | Cybersource | 0 | Approved | PAY-0000008 | Online | 1.0027 | GW-TRX-5187601 | Cybersource | settled | 0 | Approved | 802.45 | USD | payment | Amex | 8.02 | 794.43 | 2025-02-25 | PAY-0000008 | Yes | PROC-TRX-36380772 | Amex | payment | 12.04 | 782.39 | 2025-02-26 | SET-20250225-Amex-Amex-USD | USD | PAY-0000008 | Yes | 2025-02-27 | USD | SET-20250225-Amex-Amex-USD | 235013.68 | 0.0 | Yes |
| 9 | payment | 2025-02-23 | USD | CUST16887 | 4780.71 | Credit Card | Mastercard | PROC-56406364 | Cybersource | 0 | Approved | PAY-0000009 | Online | 0.9977 | GW-TRX-8963563 | Cybersource | settled | 0 | Approved | 4780.71 | USD | payment | Mastercard | 47.81 | 4732.90 | 2025-02-23 | PAY-0000009 | Yes | PROC-TRX-55314596 | ClientLine | payment | 47.81 | 4685.09 | 2025-02-26 | SET-20250223-ClientLine-Mastercard-USD | USD | PAY-0000009 | Yes | 2025-02-27 | USD | SET-20250223-ClientLine-Mastercard-USD | 178556.96 | 0.0 | Yes |
| BS_Record_Type | BS_Transaction_Date | BS_Currency | BS_Customer_Number | BS_Amount | BS_Payment_Method_Type | BS_Card_Type | BS_Processor_Transaction_Id | BS_Payment_Gateway | BS_Processor_Response_Code | BS_Processor_Response_Message | BS_Inv_Payment_Number | BS_Sales_Channel | BS_Foreign_Exchange_Rate | GW_Transaction_ID | GW_name | GW_Transaction_Status | GW_Response_Code | GW_Response | GW_Transaction_Amount | GW_Trx_Currency | GW_Trx_Type | GW_Card_Brand | GW_fees | GW_Net_Settled_Amt | GW_Trx_Date | GW_Ref_Number | BS_GW_Match | MP_Trx_ID | MP_Processor_Type | MP_Trx_Type | MP_Processor_Fee | MP_Settled_Amount | MP_Settlement_Date | MP_Settlement_Batch | MP_Trx_Currency | MP_Order_ID | PG_MP_Match | Bank_Deposit_Date | Bank_Deposit_Currency | Bank_Deposit_Ref_Number | Bank_Credits | Bank_Debits | end_to_end_recon_match | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 141240 | chargeback_reversal | 2025-03-26 | USD | CUST35141 | 689.24 | ACH | ACH | PROC-27835908 | GoCardless | C02 | Chargeback Reversed | PAY-0107910 | In-Store | 0.9972 | GW-TRX-2559292 | GoCardless | settled | 00 | Approved | 689.24 | USD | payment | GoCardless | 1.72 | 687.52 | 2025-03-26 | PAY-0107910 | Yes | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | No | NaN | NaN | NaN | NaN | NaN | No |
| 141241 | chargeback_reversal | 2025-03-06 | USD | CUST38615 | 2318.44 | Credit Card | Mastercard | PROC-12729812 | Cybersource | C02 | Chargeback Reversed | PAY-0024103 | In-Store | 0.9920 | GW-TRX-7827390 | Cybersource | settled | 0 | Approved | 2318.44 | USD | payment | Mastercard | 23.18 | 2295.26 | 2025-03-06 | PAY-0024103 | Yes | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | No | NaN | NaN | NaN | NaN | NaN | No |
| 141242 | chargeback_reversal | 2025-03-11 | CAD | CUST33012 | 4353.13 | Credit Card | Amex | PROC-47353736 | Cybersource | C02 | Chargeback Reversed | PAY-0039969 | In-Store | 0.7286 | GW-TRX-4868451 | Cybersource | settled | 0 | Approved | 4353.13 | CAD | payment | Amex | 43.53 | 4309.60 | 2025-03-11 | PAY-0039969 | Yes | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | No | NaN | NaN | NaN | NaN | NaN | No |
| 141243 | chargeback_reversal | 2025-01-31 | GBP | CUST29916 | 28.61 | PayPal | PayPal | PROC-65209114 | PayPal | C02 | Chargeback Reversed | PAY-0101060 | Online | 1.2621 | GW-TRX-2579080 | PayPal | settled | 00 | Approved | 28.61 | GBP | payment | PayPal | 0.21 | 28.40 | 2025-01-31 | PAY-0101060 | Yes | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | No | NaN | NaN | NaN | NaN | NaN | No |
| 141244 | chargeback_reversal | 2025-01-24 | USD | CUST20753 | 2263.30 | ACH | ACH | PROC-90546965 | GoCardless | C02 | Chargeback Reversed | PAY-0020178 | Online | 0.9962 | GW-TRX-6667190 | GoCardless | settled | 0 | Approved | 2263.30 | USD | payment | GoCardless | 5.66 | 2257.64 | 2025-01-24 | PAY-0020178 | Yes | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | No | NaN | NaN | NaN | NaN | NaN | No |
| 141245 | chargeback_reversal | 2025-03-12 | USD | CUST16969 | 2573.44 | ACH | ACH | PROC-65330212 | GoCardless | C02 | Chargeback Reversed | PAY-0025245 | Online | 0.9928 | GW-TRX-4965129 | GoCardless | settled | 0 | Approved | 2573.44 | USD | payment | GoCardless | 6.43 | 2567.01 | 2025-03-12 | PAY-0025245 | Yes | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | No | NaN | NaN | NaN | NaN | NaN | No |
| 141246 | chargeback_reversal | 2025-01-01 | EUR | CUST33287 | 794.03 | Credit Card | Amex | PROC-79034160 | Cybersource | C02 | Chargeback Reversed | PAY-0093761 | Online | 1.0854 | GW-TRX-9449979 | Cybersource | settled | 0 | Approved | 794.03 | EUR | payment | Amex | 7.94 | 786.09 | 2025-01-01 | PAY-0093761 | Yes | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | No | NaN | NaN | NaN | NaN | NaN | No |
| 141247 | chargeback_reversal | 2025-02-13 | USD | CUST12112 | 3629.53 | PayPal | PayPal | PROC-53163760 | PayPal | C02 | Chargeback Reversed | PAY-0103102 | Online | 0.9919 | GW-TRX-7642246 | PayPal | settled | 00 | Approved | 3629.53 | USD | payment | PayPal | 27.22 | 3602.31 | 2025-02-13 | PAY-0103102 | Yes | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | No | NaN | NaN | NaN | NaN | NaN | No |
| 141248 | chargeback_reversal | 2025-02-10 | USD | CUST27487 | 2700.28 | Credit Card | Mastercard | PROC-29829469 | Cybersource | C02 | Chargeback Reversed | PAY-0039089 | Phone | 0.9963 | GW-TRX-5426672 | Cybersource | settled | 0 | Approved | 2700.28 | USD | payment | Mastercard | 27.00 | 2673.28 | 2025-02-10 | PAY-0039089 | Yes | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | No | NaN | NaN | NaN | NaN | NaN | No |
| 141249 | chargeback_reversal | 2025-01-05 | CAD | CUST23398 | 2500.12 | ACH | ACH | PROC-69324390 | GoCardless | C02 | Chargeback Reversed | PAY-0022422 | Online | 0.7254 | GW-TRX-9447663 | GoCardless | settled | 0 | Approved | 2500.12 | CAD | payment | GoCardless | 6.25 | 2493.87 | 2025-01-05 | PAY-0022422 | Yes | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | No | NaN | NaN | NaN | NaN | NaN | No |